Forum Discussion

sharvan029's avatar
sharvan029
Regular Visitor
8 years ago
Solved

Compare two dimensions in a bar chart

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, 

 

  • sharvan029's avatar
    sharvan029
    8 years ago

    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

     

4 Replies

  • MattAllington's avatar
    MattAllington
    Icon for Community Champion rankCommunity Champion

    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's avatar
      sharvan029
      Regular Visitor

      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

       

      • MattAllington's avatar
        MattAllington
        Icon for Community Champion rankCommunity Champion

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