Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
128 | |
112 | |
99 | |
65 | |
62 |
User | Count |
---|---|
138 | |
116 | |
102 | |
70 | |
57 |