The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi
I have a Date table (marked as Date table) and a Fact table.
The Date table contains, amongst others, a separate Year field.
There is 1:n relations between Date – Facts.
Date table contains dates from 2010-01-01. Fact table contains data from midst 2016.
Suppose the Date table has a surrogate key, which relates him to the Fact table.
I want to create a slicer containing Years. How do I take care of the fact that this slicer will only contain Years for which there are facts?
What solutions/possibilities do I have?
Regards
Ron
Solved! Go to Solution.
@PowerRon , take a measure from fact and check for not blank
measure = sum(Table[value])
Check-in visual level filter measure is not blank.
This might not work with date range
@PowerRon , take a measure from fact and check for not blank
measure = sum(Table[value])
Check-in visual level filter measure is not blank.
This might not work with date range
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
88 | |
71 | |
65 |
User | Count |
---|---|
241 | |
124 | |
120 | |
81 | |
79 |