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.
Greetings, I want to make the current month is a default value for the (date) column.
note that I want to make this for different 3 tables, so I tried to make a relation between them on the (date) column and put a filter on one of them, but it doesn't work 😕
Any Solutions, please?
Regards
Hi @RawandShora,
Unfortablely, current power bi does not support setting default value on the slicer.
For your scenario, I'd like to suggest you create a calendar table to link your table date fields. Then you can add a calculated column with if statement to check date value and return tag. After these steps, you can use this tag to choose current month and save to bookmark to quick reset slicer to the 'default value' current month.
Regards,
Xiaoxin Sheng
Hi @RawandShora ,
You can achieve this by using hasonvalue and filter where you will compare your max month to the moth of today
Hope this helps. Thanks
@RawandShora , You have to create a date table and join it with all three tables on date.
Then you need to have month year and this column in date column
Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")
Month Type = Switch( True(),
Date([Date]) = eomonth(Today(),-1),"Last Month" , //Last Month
Date([Date])= eomonth(Today(),0),"This Month" , //This Month
[Month Year]
)
Sort both month year and month type on month year sort. Take slicer on Month Type, select current month and save
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Dafault Date/Month
https://www.youtube.com/watch?v=hfn05preQYA
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 |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |