The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi there,
I'm quiet new to the platform..
I have page filter 'date' in my dashboard. When I want to look at the past performence of the dashboard and change the page filter, the visual filter won't change according to the page filter. I wonder there is a way that change of a page filter could also impact current visual filter based on the relationship of the data.
Note that the dashboard is showing monthly data by default.
As the screenshot shown above, I change the page filter but the visual filter stay the same and the dashboard won't show past data due to the conflict.
Here is the relationship.
Solved! Go to Solution.
Hi @JaredJi ,
You may need to look carefully at your data changes again.
Please see this simple example.
In the visual-level filters, "a" and "b" are selected.
If we select "c" in the page-level filters, the visual will show blank.(Because the filtering level of page-level filters is greater than that of visual-level filters.)
If we select only "b" in the page-level filters, the visual will show "b".
The visual-level filters won't change, but the data in the visual has actually changed.
If we clear the filters in the visual-level filters at this time, you will find that only "c" is left in it.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @JaredJi ,
You may need to look carefully at your data changes again.
Please see this simple example.
In the visual-level filters, "a" and "b" are selected.
If we select "c" in the page-level filters, the visual will show blank.(Because the filtering level of page-level filters is greater than that of visual-level filters.)
If we select only "b" in the page-level filters, the visual will show "b".
The visual-level filters won't change, but the data in the visual has actually changed.
If we clear the filters in the visual-level filters at this time, you will find that only "c" is left in it.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yeah but what if I want the page filter go beyond the visual filter. I tried that and the dashboard doesn't return the past data beyond the visual filter, e.g.. in my case It only shows the data from 01/03/2022 onward.