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 a table and graph , table contains 4 category and locations which percent of column total, like below,
I want to create bar chart with only 1 category, when i am selected percent of column total option it is showing wrong figures, I want to show highlighted one in bar chart
In table i am switch to selecte MTD QTD
@Anonymous , Not very clear. You can drag the same measure again and right click use % of total from the option.
Or use clustered line visual.
Or create a measure like
divide([measure], calculate([measure],all(table)))
or
divide([measure], calculate([measure],allexpcept(table,table[category])))
@amitchandak In bar chart in only shows option % of Grand total, where as i am trying to do it as %of Col total. I am not able to write correct dax for that.
In Bar chart i am not getting %of Col total option
using this is giving divide([measure], calculate([measure],allexpcept(table,table[category]))) me wrong result
Hi, @Anonymous
Not fully sure what is your question, can you elaborate a bit more to explain what you are trying to do.
Best Regards,
Community Support Team _ Eason
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 |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |