Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Weird one here.
I have a page set up like this, with the following filters on page/visual level:
Basically what this is for is to show us what's unallocated and in order for me to know what's unallocated, I've set the date to 31/12/2024 and set the visual to only show data that has a date of 31/12/2021 when you click to see the unallocated streams. The equpiment one is working fine and is set up exactly the same. They are not linked to the main DimDate table, but they are linked through a MonthYr table I created just for them, as it's independent from anything else. Install is only showing me c. £70k when it should be more like c. £154K. The install and equpiment both pull from sep. sheets and I've made sure I'm using the right data for the right stream.
So if I copy the visual to a completely new page, with all the filters still the same, this is what I get:
Which is correct and what I expected on the other page, but it just won't show up. Any ideas?
Solved! Go to Solution.
@smather Tough to say. What other visuals are on that first page that are interacting with the visual in question? Is there a hidden "sync slicer" on the page maybe?
@smather Tough to say. What other visuals are on that first page that are interacting with the visual in question? Is there a hidden "sync slicer" on the page maybe?
.... something so simple, I'm stupid. Thanks @Greg_Deckler -- this page is actually a bookmark, and the main page had a slicer on it (Year, from DimDate) which was filtering my visuals on the bookmark. Went through the interactions, stopped them, and now I'm getting the figure I was expecting!
@smather Don't worry about it, been there. Bookmarks and such get crazy and it gets the best of us at times! 🙂
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
104 | |
99 | |
97 | |
41 | |
38 |
User | Count |
---|---|
151 | |
123 | |
79 | |
73 | |
71 |