Forum Discussion

davidwsw's avatar
davidwsw
Frequent Visitor
9 years ago
Solved

Need help filtering a radar chart

I have a simple table where users have scores for different categories. There are 5 categories in total but some users don't have a score in certain categories. For example, Paul has a score in categ...
Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    davidwsw

     

    You can create another User table with following formula. And create relationship between Table1 and Table2 with User key but inactive the relationship.

    Table2 = 
VALUES ( Table1[User] )

     

    Then create a Measure with following formula.

    AverageScore = 
CALCULATE (
    AVERAGE ( Table1[Score] ),
    USERELATIONSHIP ( Table1[User], Table2[User] )
)

    For the Slicer visual, select Table2[User] in the Field. Then the selection in Slicer will not filter the category in the Rader chart.

     

    Best Regards,

    Herbert

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

davidwsw

 

You can create another User table with following formula. And create relationship between Table1 and Table2 with User key but inactive the relationship.

Table2 = 
VALUES ( Table1[User] )

 

Then create a Measure with following formula.

AverageScore = 
CALCULATE (
    AVERAGE ( Table1[Score] ),
    USERELATIONSHIP ( Table1[User], Table2[User] )
)

For the Slicer visual, select Table2[User] in the Field. Then the selection in Slicer will not filter the category in the Rader chart.

 

Best Regards,

Herbert

  • davidwsw's avatar
    davidwsw
    Frequent Visitor
    9 years ago

    v-haibl-msft

     

    Thanks! Your solution worked.