Forum Discussion

talderton's avatar
talderton
Frequent Visitor
4 years ago
Solved

Horizontal bar charts

How can I produce a horizontal bar chart in Power BI that has rows of data (schools) with 3 columns of data (years) showing a % in respect of a table calculation for a dimension (Test score band) that has 3 categories  (High, medium and low) with two of the categories being hidden to just show the % for the 'High' category in each column.

Like this one I have done in Tableau (schools on the left are not shown, and the table is sorted on the 2022 figures):

 

 

Need Help

1 Reply

  • ronaldbalza2023's avatar
    ronaldbalza2023
    Icon for Continued Contributor rankContinued Contributor
    4 years ago

    Hi talderton , hope you are having a good day. You can achieve it using small multiples in bar chart visual. Attached sample pbix and have a play around with it ğŸ˜‰