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

[Gaurav51478]

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 chart

[amitchandak]

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

[Gaurav51478]

@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

[v-easonf-msft]

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