Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
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! 🙂
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
| User | Count |
|---|---|
| 47 | |
| 43 | |
| 40 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 70 | |
| 67 | |
| 32 | |
| 27 | |
| 25 |