Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have the below table:
(Columns Revenue 1, 2,3 are just different groups… the revenue shall appear in only one of them… either 1,2 or 3… and then repeated in ‘Revenue’ column).
I want to create a stacked bar chart… (like below)
Where in the Y axis, I shall have custom bins (ie 0-100, 101-200 and 201-100000). And in the x axis a stacked with a count on distinct clients.
What I have so far is 3 measures (see below) to achieve the distinct count on the clients, but I am unable to produce the bins and display it in the y axis as above, how can I achieve it??
CALCULATE(DISTINCTCOUNT('Fact'[Key_Customer]), FILTER('Fact','Fact'[Revenue1]>0))
CALCULATE(DISTINCTCOUNT('Fact'[Key_Customer]), FILTER('Fact','Fact'[Revenue2]>0))
CALCULATE(DISTINCTCOUNT('Fact'[Key_Customer]), FILTER('Fact','Fact'[Revenue3]>0))
Hopefully your source data comes in a better format. Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services.
User | Count |
---|---|
21 | |
19 | |
12 | |
9 | |
7 |
User | Count |
---|---|
30 | |
27 | |
14 | |
13 | |
11 |