Forum Discussion
How to make my expression dynamic by passing variable thru Slicer ?
Hi All
Anonymous , Based on what I got.
One option - Bookmark and buttons. - https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
refer to these two
Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/
5 Replies
- amitchandakSuper User
Anonymous , if you slicer from the table or table joined to it you do need to use selected value. Also what do you mean by not dynamic ?
use in 'SALES'[GROUP_CLASS] in values( 'SALES'[GROUP_CLASS]) for all values. Selectedvalue will give only one value.
- AnonymousNot applicable
Hi Amit
Thank you for your fast reply.
Dynamic = Only using one Table and user can select to view report Brand or SBU by click the Slicer.
Paul
- amitchandakSuper User
Anonymous , Not clear. Can you explain