show 2 measures in clustered bar chart

[Anonymous]

Hi , i have to show 2 measures either in bar chart or column chart .I have shown "MLS records" but unable to show "total cloud cost"

.how can i show both values in same chart. i have attached the pbix file.

eos.pbix 

[MFelix · Accepted solution]

Hi @Anonymous ,

This as to do with the options you are using on your chart, when you place the legend values you are not abble to add more than 1 value/ measure to your chart.

You would need to creat a measur for every status so you would have 6 to 8 measure based on the 3/4 status you have.

since you have filtered out to the status end of support you don't need to place the legend in the chart.

[Anonymous]

thanks @MFelix  it solved the issue.

I'm new to power bi , can you tell what did you mean by saying"creat a measur for every status".what status did you mean

[MFelix]

Hi @Anonymous

On Power BI you canuse the columns to fill your visuals or create measure that are calculations that are called upon when you run your visialization.

On those measure you can add filters and complex calculations in order to achieve your objectives, in your case you have several status so if you wanted to have all the status on your chart based on both columns you would need to make measures.

Check the link below explaining measures.
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

Can I also please ask you to mark the answer as accepted so can help others when searching the forum