Bar chart how to add % contribution on X Axis ?

[admin11]

Hi All

https://www.dropbox.com/s/11a6599wncx37h5/PBT_V2021_333%20stock%20by%20year%20display%20percentage%2...

Above is my PBI file

Paul

[amitchandak · Accepted solution]

@admin11 , Use clustered line visual. Add the same measure online and right in the visual pane and use show as a percent of total

[amitchandak · Accepted solution]

@admin11 , you can drag the same measure twice. Use one for % of total 

[OwaisAkber]

Contribution option is disabled in new version. I'm unable to create bar chart with contribution. Can anyone help in this?

[amitchandak · Accepted solution]

@admin11 , Use clustered line visual. Add the same measure online and right in the visual pane and use show as a percent of total

[admin11]

@amitchandak 

Yes , this is what i want. 

follow up question , it there a way i can make both aount and % contribution on same chart ?

Paul

[amitchandak · Accepted solution]

@admin11 , you can drag the same measure twice. Use one for % of total 

[admin11]

@amitchandak

i have try , now my issue is how to make % shown on right side Y axis and left side Y axis show Amount ?

[Anonymous · Accepted solution]

Hi @admin11,

Perhaps you can try to create a custom store table with all types of categories with custom index and setting sort by column with index.

Custom Sorting in Power BI 
Then you can link to raw table fields and use new table fields as the axis on visual.
Regards,

Xiaoxin Sheng