Forum Discussion
Dynamic Column based on 2 Date slicer selections
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.
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.
2 Replies
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/
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.
