cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

3 REPLIES 3
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)))

or


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

 

 

image.png

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

Announcements
secondImage

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.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

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