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?

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
8 years ago

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