Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |