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.
Hi All,
Is there any way to set the default value based on the condition?
EX: I have a number column and a flag. Here I need to have a slicer with number columns and the default selection would be based on the flag where the flag value=Y then that related number value has to be selected by default.
Thanks in advance,
Rakesh
Hi @Raki39 ,
Try creating a new field in Power Query using this:
if Flag = "Y" then "defaultvalue" else "value"
In place of defaultvalue and value, you can put a column name else the default value that you need.
@Raki39 -> If this helps you then please mark it as a solution and hit the thumbs up. Thank you.
Hi @truptis Thank you for the response. Here In my case, I dont have the previlage to create new column as the connection is a live connection. is there any way that I can do it writing a measure?
So sorry I missed to mention it.
Hi @Raki39 ,
As per my knowledge, this feature is not supported yet in Power BI slicer.
You can use bookmarks to set a stand default filter button, and another as clear all filters
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |