Forum Discussion

ChainsawMan's avatar
ChainsawMan
Icon for Helper I rankHelper I
3 years ago
Solved

Need a customed bar chart

Hi All,

 

I need a bar chart like a multi row card. Can I achieve this effect?

Thanks in advance!

Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi , ChainsawMan 

    Thanks for your quick response!You want to place the x-axis on top of the bar chart.

    I'm sorry, but I've been searching for a long time and haven't found a bar graph visual that puts the Y axis on top of the X axis.

    For your need , you can try to use the Matrix as a workaround.

    This is my test data:

    Now we can put this in the Matrix:

    Then we can give the "Values" a "Conditional formatting-Data bars".

    Then we can get the visual like this:

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

5 Replies

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi , ChainsawMan

    Based on your sample screenshot and description provided, I think you want to achieve a bar chart with the total row displayed above, right?

     

    If so, you may try my method to achieve the similiar output as yours in the Power BI:

    This is my test data table:

     

    You can first create a calculated table like this:

    Table with total column =
var _total=SUMX(ALL('Table'),'Table'[Value])
var _row=ROW("Year","Total","Value",_total)
return
UNION('Table',_row)

     

     

    Then you can try to create a "Clustered bar chart" and place the fields within the calculated table like this:

     

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

    • ChainsawMan's avatar
      ChainsawMan
      Icon for Helper I rankHelper I
      3 years ago

      Hi StarLight Aniya,

       

      I want to place the x-axis on top of the bar chart, can I do it? Currently the x-axis is on the left side of bar.

       

      • v-yueyunzh-msft's avatar
        v-yueyunzh-msft
        Icon for Community Support rankCommunity Support
        3 years ago

        Hi , ChainsawMan 

        Thanks for your quick response!You want to place the x-axis on top of the bar chart.

        I'm sorry, but I've been searching for a long time and haven't found a bar graph visual that puts the Y axis on top of the X axis.

        For your need , you can try to use the Matrix as a workaround.

        This is my test data:

        Now we can put this in the Matrix:

        Then we can give the "Values" a "Conditional formatting-Data bars".

        Then we can get the visual like this:

        Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

         

        Best Regards,

        Aniya Zhang

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    3 years ago

    Hi ChainsawMan .
    By using conditional formatting in a table and grouping with a text box, you can create a chart with a "filling" effect similar to yours.
    Attached is a picture of the result.

    The file I used to follow my steps can be downloaded from this link:
    Link to the PBIX 

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • ChainsawMan's avatar
      ChainsawMan
      Icon for Helper I rankHelper I
      3 years ago

      Hi Ritaf1983,

       

      I want to place the x-axis on top of the bar chart, can I do it?