Forum Discussion

RPAI2812's avatar
RPAI2812
Helper I
4 years ago
Solved

Multiple slicer selection with multiple values not displaying

Hello!

 

I have a radar plot, which I have three measures associated:

  • KPI1
  • KPI2
  • KPI3

In each of those measures I return the value depending on a SELECTED VALUE form a column called "unit". Below is just an example to illustrate something simitar that is written:
Example:
KPI1 = IF(SELECTEDVALUE('Table 1'[Unit]="Unit 1"), [Data 1], BLANK())
KPI2 = IF(SELECTEDVALUE('Table 1'[Unit]="Unit 2"), [Data 2], BLANK())
KPI3 = IF(SELECTEDVALUE('Table 1'[Unit]="Unit 3"), [Data 3], BLANK())

Ps: The [Data X] measures are just calculated measures to return what I want, but it is not that relevant here.


When I select only one of the units from the "Unit" slicer, the plot is perfect and displays what I want.

 

However, if I select more than one unit, no data appears, the radar keeps blank. I wish I could display multiple radar plots so I can compare the KPIs between units. Is there a way I can rewrite my code so that if I multiple select units on my slicer, the ones I select display normally?

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    4 years ago

    RPAI2812 , Try like

     

    KPI1 = IF(countx(filter('Table 1','Table 1'[Unit]="Unit 1"),[Unit]) >= 1, [Data 1], BLANK())
    KPI2 = IF(countx(filter('Table 1','Table 1'[Unit]="Unit 2"),[Unit]) >= 1, [Data 2], BLANK())
    KPI3 = IF(countx(filter('Table 1','Table 1'[Unit]="Unit 3"),[Unit]) >= 1, [Data 3], BLANK())

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    RPAI2812 , Try like

     

    KPI1 = IF(countx(filter('Table 1','Table 1'[Unit]="Unit 1"),[Unit]) >= 1, [Data 1], BLANK())
    KPI2 = IF(countx(filter('Table 1','Table 1'[Unit]="Unit 2"),[Unit]) >= 1, [Data 2], BLANK())
    KPI3 = IF(countx(filter('Table 1','Table 1'[Unit]="Unit 3"),[Unit]) >= 1, [Data 3], BLANK())