Forum Discussion

jvirgi's avatar
jvirgi
Helper III
6 years ago
Solved

Comparing Values and scorecards based on a lookup table

I have 2 tables of data (see below example), 1 with a listing of a bunch of reviews on sports with a star rating.  I have another table thats a reference that says what sport i should benchmark it ag...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    Hope this can help:

    Here is my test pbix file:

    pbix 

     

    Best Regards,

    Giotto

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

Hi,

 

Hope this can help:

Here is my test pbix file:

pbix 

 

Best Regards,

Giotto

  • jvirgi's avatar
    jvirgi
    Helper III
    6 years ago

    v-gizhi-msft Thanks!!  This works well and what I was looking for.

     

    Is there a way to show the red / green chart to just be indiviual card visuals or single colored boxes for each sport? I know i could create a bunch of slicers only linked to each visual but that seems very messy.  I was thinking can i make a card that just links to the first sport, another for the 2nd, and so on.