Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there,
The question might be a bit confusing but it's just a simple enquiry, I have a visual like this below:
This displays a % of a grand total of userid count. And I also have a mini card visual in the top right corner that says a 100% with the exact same column applied too it (with % of grand total)
However, I want the top right card visual to show and add up %'s when multiple bars are clicked on the report, such as below:
As you can see, the first 3 bars have been highlighted (clicked on), but the top right % is still 100%, I want it to show the total % highlighted which would be 27.63%. I figured with both visuals sharing the exact same value, it would automatically do this but it isn't.
How would this be possible? And is it possible?
Solved! Go to Solution.
Hi guys, figured it out. I needed to filter the other category on the visual for it to work, however, blanks were also filtered out so I made sure to filter it with > 1 (categories were numerical)
Hi guys, figured it out. I needed to filter the other category on the visual for it to work, however, blanks were also filtered out so I made sure to filter it with > 1 (categories were numerical)
Hi,
Share the link from where i can download your PBI file.
Hi @Ashish_Mathur
Thank you but unfortunately the file has too much confidential data and it would take a really long time to make a dummy file. Do you know of how to create a measure that can do this function that I request?
Hi @KA95 ,
Is the percentage value a measure?
If so you could create a new measure using SUMX() function and put it in the card visual.
Like:
SUMX(table,[percentage])
Best Regards,
Jay
Hi @v-jayw-msft
Yes on both visuals the value's are measures, I've tried that very measure you made and it's not working, the %'s aren't the same as the %'s on the graphic.
So if I use this measure
I put in the / 1000 to lose the 0's on the %, but it's still not working properly as shown below:
Do you know why that is?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
102 | |
78 | |
76 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |