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 ...
Need Help
  • 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

     

MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
8 years ago

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
    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

     

    • MattAllington's avatar
      MattAllington
      Icon for Community Champion rankCommunity Champion
      8 years ago

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

       

    • v-ljerr-msft's avatar
      v-ljerr-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi sharvan029,

       

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

       

      Regards