Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago
Solved

Show data when selecting an option

I want you to click on a combobox (Data Segmentation), to show me the selected data. For example. In this image I have several comboboxes and when selecting a "client" that shows me the...
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi, Syndicate_Admin 

    According to your requirements description, my understanding is that you want to achieve that when you don't select the value of "Client" in the slicer of the report, you want to not display any value corresponding to the client or other values in the corresponding visual, right?

    If that's the case, you can try my scheme to achieve this requirement, I made a simple example data based on your situation:

    (1)You can start by creating a separate table for the "Client" field placed in a slicer and ensuring that there is no table-to-table relationship between this table and your primary table:

    (2)Then you can write a measure for the corresponding value field placed in the visual like this:

    Value_Slicer =

var _selectedvalue=SELECTCOLUMNS('Slicer',"1",'Slicer'[Client])

return

IF(ISFILTERED(Slicer[Client]),SUMX(FILTER('Table','Table'[Client] in _selectedvalue),'Table'[Value]),BLANK())

    (3)Then you can go to the visual and replace the corresponding value field with the measure you just created, and your requirements are realized:

    Best Regards,

    Aniya Zhang

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

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi, Syndicate_Admin 

According to your requirements description, my understanding is that you want to achieve that when you don't select the value of "Client" in the slicer of the report, you want to not display any value corresponding to the client or other values in the corresponding visual, right?

If that's the case, you can try my scheme to achieve this requirement, I made a simple example data based on your situation:

(1)You can start by creating a separate table for the "Client" field placed in a slicer and ensuring that there is no table-to-table relationship between this table and your primary table:

(2)Then you can write a measure for the corresponding value field placed in the visual like this:

Value_Slicer =

var _selectedvalue=SELECTCOLUMNS('Slicer',"1",'Slicer'[Client])

return

IF(ISFILTERED(Slicer[Client]),SUMX(FILTER('Table','Table'[Client] in _selectedvalue),'Table'[Value]),BLANK())

(3)Then you can go to the visual and replace the corresponding value field with the measure you just created, and your requirements are realized:

Best Regards,

Aniya Zhang

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