Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

how to can show percent of column total in bar chart with category filter

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

 
 
 
 

I want to highlighted in bar chartI want to highlighted in bar chart

3 REPLIES 3
amitchandak
Super User
Super User

@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])))

 

Anonymous
Not applicable

@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

 

 

image.png

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.