Forum Discussion
Solved
Format default visual (bar chart)
Hi, I have a bar chart, at the moment the user can filter it using a slicer - just 3 different departments. I would like to give the bars different colors depending on the selected department and sho...
SIH007_1 Step 1: First create a Measure like below (As per your need) - If Proj ID is 1 so it will show Red and if 2 so it will show in Green.
Measure Color = SWITCH(TRUE(),MAX('Proj Table'[Proj ID])=1, "Red",MAX('Proj Table'[Proj ID])=2,"Green")Step 2: Use this measure in Color funtion of bar chart:Step 3: Then select Field option and use the Measure color:
Step 4: Final result based on Proj ID slicer.
