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! Could anyone show me how to show a percent of column total in my chart? I only have the choice % of grand total. I would like to show the percent of column total as in the matrix table (screen shot). Please? Best regards Michael
Solved! Go to Solution.
Hi @Micnorex,
If I understand you correctly, you should be able to use the formula below to create a new measure to calculate the percent of column total, and show the measure as Values on the Chart to get the expected result in your scenario.
Measure = DIVIDE ( COUNTA ( 'Sheet1'[Number] ), CALCULATE ( COUNTA ( 'Sheet1'[Number] ), ALL ( 'Sheet1'[Alder] ) ) )
Regards
Hi @Micnorex,
If I understand you correctly, you should be able to use the formula below to create a new measure to calculate the percent of column total, and show the measure as Values on the Chart to get the expected result in your scenario.
Measure = DIVIDE ( COUNTA ( 'Sheet1'[Number] ), CALCULATE ( COUNTA ( 'Sheet1'[Number] ), ALL ( 'Sheet1'[Alder] ) ) )
Regards
Thank you, that made the trick. Really appreciate it!
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 |
---|---|
107 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |