Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I've got two tables: one is 'sales' data with a single date column; one is 'date' data containing ISO weeks, periods and years, etc.
I've linked the two tables so that I can filter my sales data using the various date information held in the date table. It works well, but the slicers linked to the date table show ALL the values from that table, even though there is not necessarily sales date for all of the dates.
Is there a way to limit what is shown in the date slicers so that only dates relevent to the data in the sales table are shown?
Cheers,
Matty
Hi @Matty,
You can create a calculated column in 'date' table using the formula.
column=RELATED(sales[sale])
Create a New Table based on the column above.
New Table=FILTER('date','date'[column]<>BLANK())
Finally, create a slicer using the field in New Table.
Best Regards,
Angelia
Sure, just add a filter to the slicer to filter out dates with no sales data.
Hi there,
You could create a seperate data table using the calendar function.
Date =CALENDAR (DATE(2000;1;1); DATE(2025;12;31))
Here you could set the maximum date to the latest date in your sales column.
Additionally you could create a slicer that is based off of the sales data. This will only show values that exist within this table.
Thanks,
J
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |