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.
Hi please help me with this.. i would like to see a stacked up monthly comparison.
For example, below's data is from Dec 2023 to Jan 2023
Country | User Count (Distinct) | % |
Singapore | 10 | 9% |
Malaysia | 15 | 13% |
Indonesia | 22 | 19% |
India | 45 | 39% |
Thailand | 23 | 20% |
Total | 115 | 100% |
below is Dec 2023 to feb 2023
Country | User Count (Distinct) | % |
Singapore | 15 | 12% |
Malaysia | 10 | 8% |
Indonesia | 27 | 21% |
India | 40 | 33% |
Thailand | 30 | 26% |
Total | 122 | 100% |
what i want to have as outcome in bar chart e.g. singapore
Jan : 9%
Feb : 12%
Please let me know if this is possible. Thanks!
Solved! Go to Solution.
Yes, if you only want to show 1 country at a time you could just not put it in the Axis but use a filter instead.
I just saw this in my head when reading your description.
Sounds like you want a bar chart where the Axis is the city and the legend is the month?
Hi, maybe i will have the city as the filter? but in the chart, i would want to see axis is the month, while values will be the %
Yes, if you only want to show 1 country at a time you could just not put it in the Axis but use a filter instead.
I just saw this in my head when reading your description.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
142 | |
71 | |
64 | |
52 | |
50 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |