Creating a High-Low Chart

Data Visualizations
1

Hi everyone,

I am trying to create a dashboard in which to show the cash balance on monthly basis. The monthly basis is fine. However, I dont know how to get a chart to show the high-low balances so wanted to see if you guys have done something similar. I am able to get the highest level of cash and the lowest level using dax. However, I am not sure how to use the chart to show it.
Screenshot

Attached is the graph I would like to achieve in my dashboard.

Thanks

1 Like
2

take a look at this post from @MudassirAli, showing how to create a lollipop chart (which is what you are showing) using the custom visual Charticulator, which lets you create your own visuals.

1 Like
3

Hi @Heather. Thanks for getting back to me on this. Unfortunately, the Lollipop Charts didn’t give me the result. Not sure if I am using it the wrong way or what.

The way I want to get the result might be better explained through this example:

Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21
HSBC Current Account 1770905 1574348 1770433 1587364 1324485 1585777
Highest balance 1964777 1865344 1982089 1818100 1668019 1903240
Lowest balance 1693073 1574348 1563107 1557856 1239861 1289604
Coop Current Account 147244 120286 147299 106058 180297 198415
Highest balance 266671 147244 147299 154727 180297 198415
Lowest balance 85386 102842 121891 106047 106058 139520

As you can see, the starting and ending point at each month is different and certainly not zero. This was one thing that I didn’t manage to get.

Secondly, the dot in the like represents the closing balance and again, this could be the highest balance, lowest balance, or somewhere in the middle. I didn’t manage to get the chart to work.

Have I missed something?

4

can you provide a PBIX file with a sampling of data (anonymized), showing what measures you have created this far?

if you’re not sure how to prepare the PBIX file, please see this topic:
https://forum.enterprisedna.co/t/tip-tools-and-techniques-for-providing-pbix-files-with-your-forum-questions/17763?u=heather

5

OK. Let me get the file and come back to you. Probably a bit later in the day today.

1 Like
6

@Jawed ,

Take a look at this video and see if this chart might work well for your prposes:

  • Brian
1 Like
7

Thank you, @BrianJ. This is indeed the chart and method I wanted.

8

@Jawed ,

Great - glad that got you what you needed.

  • Brian
2 Likes