Bar chart with true/false ratio

[Stefaan-4365]

Hello

I have a table with three columns true/false, let's call them isTested, isDeployed, and isAccepted. From these columns I need to create a bar chart that shows each of these columns in two colors representing the true/false ratio. This turns out to be much harder than I expected, and any help would be greatly appreciated!

Thank you
Stefaan

[Greg_Deckler]

So generally you would unpivot those three columns in Power Query and then things become much easier.

[parry2k · Accepted solution]

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

[Stefaan-4365]

Thank you so much @parry2k  for your clear instructions, this is exactly what I needed.