Dynamic Filters on Dimension and Measures

what happened to proposed solution, did you tried it?

I cant use aggrgated function as I need whole olumn value to display

Hi Anonymous,

Please create a table inclusing dimension value, create another measure using switch function. More details, please review this blog.

Best Regards,
Angelia

Hi Anonymous,

Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. More people will get useful information from here.

Thanks,
Angelia

Hi Guys,

I found an interesting and useful solution by Angelia, where we can do a Dynamic Selection on Measures list.

We could achieve Dynamic Dimension Selection as well with Quick work around.
You can refer by blog....
https://wordpress.com/post/gunaseelangnanavadivel.wordpress.com/23

Happy learning!
Thanks.

Guna

gnanavadivel100link doesn't open, although I already did it recently but would like to see what are the other methods.

Please try with the below

https://gunaseelangnanavadivel.wordpress.com/2018/07/14/powerbi-dynamic-view-based-on-dimension-selection/

Cheers,

Guna