Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Everyone,
I have two fields Month_1 and Month_2.In this two fields I have same set of Month/Year values.
I should be able select any month in Month_1 and another month in Month_2 in slicer.
The data for these two months should get sliced as separate dataframe or should be able to get identified in some other calculated column(flag of 0/1). so that I can do further calculations on data of this two selected months only.
In Spotfire I can easily do this using "Property Control" feature.
Is there any way we can implement this in Power BI?
Thanks.
Solved! Go to Solution.
Hi @siddharthkapse2 ,
You could use ALLSELECTED() function to filter your data.
You could also use ISFILTERED() function to get the status and set the flag to 0 or 1.
Hi @siddharthkapse2 ,
You could use ALLSELECTED() function to filter your data.
You could also use ISFILTERED() function to get the status and set the flag to 0 or 1.
Hhi @siddharthkapse2 ,
you may refer in this link: https://www.burningsuit.co.uk/blog/2018/03/dax-how-to-use-a-slicer-to-select-different-measures/
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |