cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
siddharthkapse2 Frequent Visitor
Frequent Visitor

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Dynamic Column based on 2 Date slicer selections

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.

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

2 REPLIES 2
Peejz_Jalmasco Regular Visitor
Regular Visitor

Re: Dynamic Column based on 2 Date slicer selections

Community Support Team
Community Support Team

Re: Dynamic Column based on 2 Date slicer selections

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.

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)