Forum Discussion
Bar chart with true/false ratio
@Stefaan-4365 as @Greg_Deckler suggests, rip the table and it can be done easily with the following steps:
- Click transform data
- Add index column from the menu
- select the index column, right-click and choose de-
you will get two columns, attribute and value, rename these columns as you want to call them.
Close and apply:
in the visual bar chart, place Attribute on the X axis, the value of the legend and count rows in the values section, and you'll get the expected results.
I'd like to❤ Complimentsif my solution helped me.👉If you can spend time posting the question, you can also make efforts to give Kudos who has helped solve your problem. It's a token of appreciation!
Community ChampionSo generally you would unpivot those three columns in Power Query and then things become much easier.
- parry2k
Super User
@Stefaan-4365 as @Greg_Deckler suggests, rip the table and it can be done easily with the following steps:
- Click transform data
- Add index column from the menu
- select the index column, right-click and choose de-
you will get two columns, attribute and value, rename these columns as you want to call them.
Close and apply:
in the visual bar chart, place Attribute on the X axis, the value of the legend and count rows in the values section, and you'll get the expected results.
I'd like to❤ Complimentsif my solution helped me.👉If you can spend time posting the question, you can also make efforts to give Kudos who has helped solve your problem. It's a token of appreciation!
