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 |
---|---|
125 | |
106 | |
99 | |
63 | |
60 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |