Showing results for 
Search instead for 
Did you mean: 
New Member

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

Super User IV
Super User IV

@Gaurav51478 , 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)))


divide([measure], calculate([measure],allexpcept(table,table[category])))


Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

@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, @Gaurav51478 


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


Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.


Power BI Women

Join our monthly meetings and learning sessions.



We are excited to announce the Power BI Super Users!


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors