Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Dynamic Visio visual based on Selection made on Slicer

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?

Need Help
Tutorial Requests

3 Replies

  • v-zhangti's avatar
    v-zhangti
    Community Support
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Charlotte,

       

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

      • v-zhangti's avatar
        v-zhangti
        Community Support
        4 years ago

        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