Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Chandrashekar
Resolver III
Resolver III

Slicer(MonthYear) vs List(Name)

‎12-17-2023 01:04 AM

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

Message 1 of 4
442 Views
0
3 REPLIES 3
Fowmy
Super User
Super User

‎12-17-2023 01:20 AM

@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

Message 2 of 4
430 Views
0
Chandrashekar
Resolver III
Resolver III
In response to Fowmy

‎12-19-2023 03:07 AM

Hello,

 

Can we do it using DAX for the same?

 

Regards,

Chandrashekar B

Message 3 of 4
376 Views
0
Chandrashekar
Resolver III
Resolver III
In response to Chandrashekar

‎12-21-2023 07:57 PM

Hello,

 

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

 

Regards,

Chandrashekar B

Message 4 of 4
351 Views
0

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.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All