selected slicer(multi select) generate multi visuals w.r.t slicer selected to show comparison

[mehupbi]

I have a slicer where different categories i will select multiple scenario id from slicer for ex: i selected three scenarioid in slicer.

i need to populate 3 stack bar visuals so that user can compare 3 visuals which is doing good.

this is just created for o/p ref, https://filetransfer.io/data-package/XCd5hSoZ#link

if i deselect any of selected value in slicer, for ex: already i have selected 3 scenario ids. if i deselect one of them, then - only two visuals i need to populate which means other one should disappear automatically.

user can select only max 4 in slicer i.e even user select more than 4 we will show only 4 visuals. if nothing selected, one visual i need to show.

am new to this, please suggest me how an i achieve this

here is  my test data https://filetransfer.io/data-package/0V4TnqIe#link

[v-linyulu-msft · Accepted solution]

Hi,@mehupbi 

To meet your needs I have created the following visualization object:

Here is my solution:

1.First, you need to create a virtual table with the following calculation table:

Table = VALUES(testdata[scenarioId])

2.I made changes to the filtering in order to limit the display to just four:

3.Finally I created the following metric and replaced it with slobVolu in the visualization object:

Measure = 
VAR _LIST = VALUES('Table'[scenarioId])
RETURN
IF(ISFILTERED('Table'[scenarioId]),IF(MAX(testdata[scenarioId]) IN _LIST,SUM(testdata[slobVolu])),IF(MAX(testdata[scenarioId]) =MAX('Table'[scenarioId]),SUM(testdata[slobVolu])))

4.Here's the final result graph, hopefully it meets your needs:

Best Regards,

Leroy Lu

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

[mehupbi]

Thanks, If i want to have table visual rather than chart? i mean generate 4 table visuals using same filter. each tabel should render each filter value. if i select 3 values in slicer, i want three table visuals w.r.t filter value selected. i dont have small multiples in table visual