Forum Discussion

SINGHTX9's avatar
SINGHTX9
Icon for Helper II rankHelper II
8 years ago
Solved

help 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...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    8 years ago

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

SINGHTX9's avatar
SINGHTX9
Icon for Helper II rankHelper II
8 years ago

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's avatar
ryan_mayu
Icon for Super User rankSuper User
8 years ago

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.