help needed with conditionally formatting a pareto chart

[SINGHTX9]

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

[ryan_mayu · Accepted solution]

Hi， please try to drag type column to 'Legend'. Is this what you want?

[SINGHTX9]

Hi 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]

Due to the internet issue, I can't see the pictures I uploaded. Here are the simple steps:

1. Edit Quires

2. Group by

3. Group by received date, Operation: "Distinct Count Rows",

4. click Ok.

Please try the steps and let me know if this can help you. Thanks

[SINGHTX9]

Hi Ryan 

Thanks for your help but i need to know the average number of tubes received daily. So from what you have given how can i write a dax measure to calculate the average?

I have inserted my actual data for your information.

https://1drv.ms/x/s!AlMqyIwZH-2XamWX-zcahxcWHWc

Thanks

[ryan_mayu]

Hi, I don't know why I can't open your actual data. Maybe you can try this DAX formula:

average number = CALCULATE(SUM(Table1[count]))/CALCULATE(DISTINCTCOUNT(Table1[received date]))

Then you can use the new measure in the report view. Hope this is helpful. Thanks.

[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.

[Anonymous]

@SINGHTX9,

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