I`m trying to build a Histogram (Column Chart) that shows the following:
x-axis: Bins based on Sum earnings for each Simulation
y-axis: Count of those simulations
Here is sample data:
|Asset Scenario||FY||Simulation Number||Earnings|
I was able to create a Column Chart BUT based on a column for the x-axis which is not subject to slicers (I will be using Asset Scenario & FY as slicers)
The chart is also based on the full data, won`t match the sample data provided.
Any way I can build this?
I think I`ll need to:
1. Write a measure that returns the sum of earnings for each simulation number
2. Build Bins based on that
3. Be able to use those bins for x-axis
But I`m not sure how to establish those
Solved! Go to Solution.
Many thanks @Ashish_Mathur for your help, this has solved the challenge for me.
For future readers, I had to change a few things to customise the provided solution to my case:
1. Removed legend
2. Expanded the bins table to match ranges of my actual data and desired bin size
3.a Created measure [E2] = DistinctCount(Simulation number) as I was looking to show that instead of measure [E]= Sum(Earnings)
3.b adjusted the provided [E by bins] based on previous point, still needed to use [E] and the formula became like this:
E by bins = CALCULATE([E2],FILTER(ADDCOLUMNS(VALUES(Data[Simulation Number]),"ABCD",CALCULATE([E],CALCULATETABLE(VALUES(Data[Simulation Number])))),COUNTROWS(FILTER(Bins,[ABCD] >= Bins[Lower] && [ABCD] <= Bins[Upper])) >0))
4. For those interested in maintaining a continuos x-axis, I have created a new numeric column showing the midpoint of the bins (on the Bins table) and used that on the x-axis instead of bin names.
I had a need to use x-axis constant lines.
Here is my replication of the provided solution.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!