Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
Is it possible to make dynamic visuals based on the selections in slicers/filters?
I'm making report where there is basically three layers of data and for one chart the data is relevant only on the lowest level. That's why I wouldn't like to present the data for two upper levels of data as it doesn't make sense. You can make measures to create the condition which is based on data, but can that be done somehow based on filter selections?
Br,
KW
Solved! Go to Solution.
Hi @KWFI1984
If it's just between a line and column chart, you can use the line and column chart combo where either the line or the columns are visible depending on slicer selections. However, for other visuals, bookmarks will be necessary.
I am not sure what's your setup, but can you just prefilter the page for the level you want? Or is there how you can define the levels?
Imagin status A is your lowest level (can be applied on visual/page level)
But if you wanna hide the the data only when things are selected, you can use ISFILTERED on your measure in the affected table or you can use bookmarks.
You can not dynamically completely hide the whole visual using filters, you can only show blank, let's say.
I am not sure what's your setup, but can you just prefilter the page for the level you want? Or is there how you can define the levels?
Imagin status A is your lowest level (can be applied on visual/page level)
But if you wanna hide the the data only when things are selected, you can use ISFILTERED on your measure in the affected table or you can use bookmarks.
You can not dynamically completely hide the whole visual using filters, you can only show blank, let's say.
Hi @KWFI1984
If it's just between a line and column chart, you can use the line and column chart combo where either the line or the columns are visible depending on slicer selections. However, for other visuals, bookmarks will be necessary.