Forum Discussion
Helper IIhelp needed with conditionally formatting a pareto chart
Hi all
I have created a pareto chart for my customer (patients). So based my selected Top N tests it is returning the pareto but i would like it to conditionally format based on the test type i.e if i select "CC" in my test type filter i want a different color to appear than when i select "IA".
Right now both IA and CC have same color and i can make out that my pareto has how many IA and how many CC.
Thank you
Hi， please try to drag type column to 'Legend'. Is this what you want?
7 Replies
Create a new table as below.
Create a measure using DAX below in your original table.Measure = SELECTEDVALUE(NewTable[Value])
Drag the measure to Color saturation of your chart, then configure the color in the chart. For more details, please review the attached PBIX file.
Regards,
Lydia
ryan_mayuSuper User
Hi， please try to drag type column to 'Legend'. Is this what you want?
SINGHTX9Hi ryan
Thanks for your perfect solution. I m new to power bi so till figuring out how to use it. Can yo help with one more thing
My data has two columns: receive date and accession id . so to get average number of tubes i need a dax measure that should divide the DISTINCTCOUNT (Accession ID)/ Number of days but i dont know how to type this measure.
let me explain you down
accession id receive date
A1234 11/30/2017
A3456 11/30/2017
A4356 12/1/2017
B1223 12/1/2017
A1234 12/2/2017
A3456 12/3/2017
so as you can see down the accession id is repeated again so i want average distinct count of accession id per day
- ryan_mayu
Please see the steps below. My test data is a little bit different from yours. But hope the result is what you want.
