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 achie...
Need Help
Tutorial Requests
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