Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
We have a table visual (visual 1) which shows data from a table in direct query mode. We have few other visuals (2,3,4) a bar chart, card, advanced card which shows some aggregated data from the same table. Visual 1 is set to interact (filter) with visuals 2,3 and 4.
There is a slicer on column 1 in table 1 which filters visual 1 correctly. When visual 1 changes visuals 2, 3 and 4 also refreshes and shows aggregated data as per the filter. So far everything is good.
Now we also have set up another slicer (Chiclet slicer) which shows 3 buttons (Year to Date, Month to Date and Week to Date). The button text comes from a temporary table column.
We have a Measure written which will be set to "Show" or "Hide" for each row based on the selected slicer value and the date column of the table. And we have a visual level filter on Visual 1 (Measure is "Show").
This works perfectly for Visual 1 which gets filtered on Slicer 2. However the associated visuals (2,3 and 4) are not getting refreshed.
We understand that this is because Slicer 2 doesn't directly filter table 1 but it only filters the visual. Tried setting the same visual level filter to visuals 2 ,3 and 4 but couldn't do it as these visuals show only aggregated data.
Is there any workaround for this problem?
hi, @sowrk
Sample pbix file and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Best Regards,
Lin
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |