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, Thank you for looking at this issue, really appreciate anyone can help me to solve this issue.
There is a slicer for examle called "city" which have 6 different cities. At the same time, i have a stacked bar chart which also puts "city" as X axis.
Will filter and select 3 cities in the slicer. Then would like to get the accordingly 3 cities in this stacked bar chart but want to have one measure - # regions for these 3 cities in total rather than # regions for each city. That means this measure should be filtered by that slicer rather than X axis of the chart.
Please see the example: so ideally, i want slicer to control the chart, and accordingly get 3 cities but hope get # regions = 120 for all these 3 cities rather than like b
Solved! Go to Solution.
Hi siyue,
If you want to get total value based on slicer, you could try below measure
Measure = CALCULATE ( IF ( ISFILTERED ( TOTAL[Country] ), SUM ( TOTAL[amount] ), 0 ), ALLSELECTED ( TOTAL ) )
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi siyue,
If you want to get total value based on slicer, you could try below measure
Measure = CALCULATE ( IF ( ISFILTERED ( TOTAL[Country] ), SUM ( TOTAL[amount] ), 0 ), ALLSELECTED ( TOTAL ) )
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, can you help me with this one? Thank you so much.
https://community.powerbi.com/t5/Desktop/Count-players-dropping-off-on-that-game/m-p/762801#M367573
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |