Forum Discussion
AdministratorSetting a default value in a slicer
good morning, I currently have a report that contains 2 slicer, one associated with years and another with months, I want to leave pordefecto every time it is opened and report are selected automatically
Hi Syndicate_Admin ,
Maybe you can try the function ISFILTERED().
IF no selection, then get MONTH of TODAY() and use CALCULATE() to sum the value of this month.
You can refer the following expression:
Total = VAR _today = TODAY() VAR _Defult = CALCULATE( SUM( 'DATE'[Value] ), FILTER( ALL( 'DATE' ), MONTH( [DATE] ) = MONTH( TODAY() ) ) ) RETURN IF( ISFILTERED( 'DATE'[Month] ), SUM( 'DATE'[Value] ), _Defult )The result:
I put the pbix file in the end you can refer.
Best RegardsCommunity Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
- AllisonKennedy
Community Champion
mancemo You can select a value in the slicers and they will be the same values you see each time you open the report.
Can you provide more detail on what you need though? Do you want the month to be dynamic and always default to current month? You may find Relative Date slicer more helpful than separate month and year slicers:
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
Syndicate_Adminhello, what I want is that when the report is opened the slicers that are showing date and year are default to the current feha and update the values of the report
the panel is this
and that when it opens automatically, year and month are selected to update the other indicators
- AllisonKennedy
It's not possible to set the default of your current slicer layout to current month. You could create a calculated column in Power Query that for example for this month of November would have the values:
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Current
Dec
And do the same for the Year. That way you could set the default value of both slicers to 'Current' and then the use can choose a different month if they desire.
To do this, click Transform Data to open Power Query.
Click Add Column tab in the ribbon, then click Custom Column and use this code:
if [Month name] = Date.MonthName(DateTime.LocalNow()) then "Current" else [Month name]
- v-chenwuz-msft
Community Support
Hi Syndicate_Admin ,
Maybe you can try the function ISFILTERED().
IF no selection, then get MONTH of TODAY() and use CALCULATE() to sum the value of this month.
You can refer the following expression:
Total = VAR _today = TODAY() VAR _Defult = CALCULATE( SUM( 'DATE'[Value] ), FILTER( ALL( 'DATE' ), MONTH( [DATE] ) = MONTH( TODAY() ) ) ) RETURN IF( ISFILTERED( 'DATE'[Month] ), SUM( 'DATE'[Value] ), _Defult )The result:
I put the pbix file in the end you can refer.
Best RegardsCommunity Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
