Forum Discussion
Stefaan-4365
6 years agoNew Member
Bar chart with true/false ratio
Hi I have a table with three true/false columns, 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 color...
amitchandak
Super User
6 years agoStefaan-4365 , Create a common dimension with the values true and false. Join them with all three columns. One will active and two will be inactive. Use userelation to make others active
How to use userelation : https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Create a color column like this
Color Date = if(FIRSTNONBLANK(Table[Value],"true") ="true","green","red")
In coditnal fomatting use it after choosing the "Field"
refer
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values