Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
By default maximum value should be selected in a slicer
example: My slicer values
if a new value(High) is added then the slicer should become like automatically.
As there is a change in our requiremnet, we are least bothered about the current issue.
Thanks for your concern.
@Naveen_Kumar wrote:
By default maximum value should be selected in a slicer
example: My slicer values
if a new value(High) is added then the slicer should become like automatically.
AFAIK, it is not possible, you can check this idea Slicer default selected values and vote it up.
I have done it. Don't know whether it is a right way but it's working fine for me.
@pxg08680 wrote:
I have done it. Don't know whether it is a right way but it's working fine for me.
Could you share me the pbix file? Does it even work when data refreshes?
Yes it works absolutely fine with data refresh.
I have few reports that run on DATE filter default selection to maxdate and this works same with other columns also.
I can give you my report as an example.
What my req is, by default the most recent date should be selected when I open the report.
STEP1:
Extract YEAR,MONTH,DAY from you dates and make the extracted column DAY as TEXT type.
STEP2:
Calculate max date from you available dates.
STEP3:
Create a new Column
The above column gives you DAY column with maxday as CURRENT(AS for my req I had written as current).
STEP4:
Drop YEAR,Month,CurrentDay into HIERARCYSLICER(*as for my req)
H
Here MAXDATE from my DATE is 11/7/2017. As for my req 7 is represented as Current.
I tried doing this with other columns also and it was working good.
Regards,
PXG08680
You're trying to make a default selection for max slicer value when ever you open your report..
I fthis is what you are trying to do it,
Step 1:
Create a calculated column , find the max value for the column that is used by the slicer.
This gives a new MAX column.
Step 2:
Create one more calculated column. Use IF statement, if the slicer column value is equal to MAX return that value, else return the rest of the values.
Step 3: Use the column that is obtained in Step2 as your new slicer column and keep the selection to the max value and save.
That's it.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
85 | |
67 | |
49 |
User | Count |
---|---|
135 | |
112 | |
100 | |
66 | |
62 |