Forum Discussion
Helper IIDynamic Slicer Default Based on Top N
I_Like_Power_BI , This column has all the values and one value default value. So means it will keep on getting all the values. Now has this column does not have account no for the first account
minx(allselected(Table),Table[Account])
Will give you the min Account number. You can use that measure in title to display the selected account No.
Super UserI_Like_Power_BI , Top N is only available at the visual level.
Maybe create a new column like this to select that.
new column =
If([Account] = min([Account]) ,"Default",[Account] & "")
And select the default, You cab show default no on a title
Helper IIamitchandak - I understand the default measure you propose, but wouldn't I have to use that at the Visual level as a filter? If so, that would limit the user to only seeing that one account, but it would also preclude them from selecting a different account if they needed to, no?
Also, I'm afraid I didn't understand this piece:
amitchandak wrote:And select the default, You cab show default no on a title
- amitchandak
I_Like_Power_BI , This column has all the values and one value default value. So means it will keep on getting all the values. Now has this column does not have account no for the first account
minx(allselected(Table),Table[Account])
Will give you the min Account number. You can use that measure in title to display the selected account No.
- I_Like_Power_BI
That did it. Thanks!