Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Creating a measure to visualize variance using color between columns based on multiple criteria

Hi - I need help in creating a measure to visualize variance using color between columns (my Report Generated Date) based on the following criteria: Customer Customer Ship-to Code Material Descri...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi Anonymous ,

     

    Please refer to my .pbix file.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi Anonymous ,

 

What fields did your three tables use to create table relationships?

Do you mind sharing your .pbix file?

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-lionel-msft 

 

Hi Lionel, 


I appreciate you getting back to me! I have attached a file that has the same layout/ tables I am using on my working file (its very large). 

 

Also, instead of changing the background color is it possible to just change the font color? I am sure I could find the answer on another thread, but thought I would ask 🙂

 

Here is the link to my file (you will have to save and download it) - it will not let me attach EDI Forecast Accuracy 

 

Appreciate your help with this!

 

Thanks,

Brittany 

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Please refer to my .pbix file.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.