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,
how to select multiple values as default in a slicer in power bi by using DAX,Can you please help me.Her
Here, in above image if you see i want to select FY2207 and HISTORICAL value by default usig DAX, when its refresh suppose FY2208 and HISTORICAL, its will autometically select these value.
@Mahmoodul , You need a new column
If ([FY Month] =max([FYMonth]) && [FY Month] = "HISTORICAL", "Current and HISTORICAL" , [FY Month])
Select Current and HISTORICAL and save,
As of now we can use measure of function to initialize that
Hi @amitchandak,
the above DAx give me both current and Historical both,This is correct result
Here, if you see above image, FY2207 is my current value, When we select "Current and HISTORICAL " its not give me desired result.
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |