Compare two dimensions in a bar chart

[sharvan029]

Hi Guys,

Is there anyway to compare two diamensions in a bar chart in Power BI,

I want a chart like below,

When i am adding these two column in power bi bar chart, it is just showing me one diamension at a time, and i want to use drill down option to see the other diamension, 

[MattAllington]

I think if you put both dimensions on the x axis, hen drill down, it may work. Also check out the infographice designer custom visual - it has some good chart features. 

[sharvan029 · Accepted solution]

Hi @MattAllington,

i wanted to see both dimensions on the chart as in the image,  I have sorted it now it like instead of bar chart we have to select table and then conditional format the value column as bar, which will give me the required chart

[v-ljerr-msft]

Hi @sharvan029,

Great to hear the problem got resolved! Could you accept your reply above as solution to close this thread? 

Regards

[MattAllington]

If you put both on an axis (1) and drill down (2), it gives a result.