Dynamic Visio visual based on Selection made on Slicer

[Anonymous]

Hi all,

1st Case: [SOLVED] I wanted my tables/charts to show blank when nothing were selected on the slicer, and only show the right data based on selection at slicer. This was successfully achieved with a new measure through DAX query that goes like these:

SlicerSelectionExt = CALCULATE(IF(ISFILTERED(External[Project]), SELECTEDVALUE(External[Project])))

Additionally for this case, I managed to get it right only once I added this new measure into visual filter and then applying "Show items when the value is not blank"

2nd Case: [UNSOLVED]  Similar idea to 1st case, but I wanted to let the Visio visual change while selecting an attribute on the slicer. For example, when selecting Project A, only visio drawing of Project A appear. When nothing is selected, the visio drawing would not show anything.

Is this possible in Power BI? Any thoughts on this?

[v-zhangti]

Hi, @Anonymous 

You can try the following methods. I simply simulated some data hoping to restore your problem.

Measure:

New value = IF(ISFILTERED(External[Project]), SELECTEDVALUE(External[Value]))

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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

[Anonymous]

Hi Charlotte,

Yes, the solution works for my Case 1. Case 2 however is yet to have any solution.

[v-zhangti]

Hi, @Anonymous 

Isn't the above diagram the result you expect from case2? What do you expect the result to look like and can you describe it graphically? I look forward to your response.

Best Regards