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.
I have survey response data showing responses over bi-week periods. I am trying to create a clustered column chart to show the preferred categories for that specific time period. The data values are showing as a percentage of the grand total and I would like for them to show as a percentage of the bi-week period.
In a matrix I have the option to show values as a percentage of column total, but in the clustered column chart I only have the option to show the values as a percentage of the grand total.
Is there a way that I can do this for the clustered column chart?
Thanks.
@Anonymous ,
Yes, the default percentage is different in this two visuals. A workaround is that you can create measures to achieve the total week percentage and drag that measure to the cluster bar chart.
Regards,
Jimmy Tao
Thanks for your response!
Could you explain to me how to create these measures to achieve the total week percentage?
Thanks!
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 |