Dynamic Column based on 2 Date slicer selections

[siddharthkapse2]

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.

[v-eachen-msft · Accepted 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.

[Peejz_Jalmasco]

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/