Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Chandrashekar
Resolver III
Resolver III

Slicer(MonthYear) vs List(Name)

Hello,

 

Can you please help me with DAX. If user select MonthYear in the slicer list should change accordingly as use may change acoordingly to the month.

 

Link: Sample File 

Chandrashekar_0-1702803776353.png

 

Regards,

Chandrashekar B

3 REPLIES 3
Fowmy
Super User
Super User

@Chandrashekar 

You need to first unpivot your table in to three columns as Name, Month- Year and Status which has either Yes or No. Refer this video: https://www.youtube.com/watch?v=Vff2kRBM95o


Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Hello,

 

Can we do it using DAX for the same?

 

Regards,

Chandrashekar B

Hello,

 

Any help on it. Is this can be done using DAX.

 

Regards,

Chandrashekar B

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.