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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Chandrashekar
Resolver III
Resolver III

Control Data : Multi Slicer

Hello,

 

How to control data with muti slicer[Date & Week No)

 

PBIX File: Sample Data 

 

Regards,

Chandrashekar B

1 ACCEPTED SOLUTION

Hello,

Thanks.

 

Regards,

Chandrashekar B

View solution in original post

6 REPLIES 6
DimaMD
Solution Sage
Solution Sage

Hi @Chandrashekar Can you provide your expected result? 
If you want to see the result by week, then add the week number in the column of the matrix table.
Screenshot_21.jpg


__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com

Hello,

 

is it possible slicer act individually. For ex:

1. If I select week then it should week wise data in both the table 

2. If I select date range it should date wise data in both the table.

 

Regards,

Chandrashekar B

@Chandrashekar Please review the attached file and tell me if this is your desired result


__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com

Hello,

If I select particular week(Week Num Slicer) date range slicer is not working. If I select date range slicer I should get data from 01-11-2022 to 22-12-2022(as per selection).

is it possible that Slicer work independently? 

Chandrashekar_1-1671612512000.png

 

 

 

@Chandrashekar Yes, you need to unfilter both tables.
Click on the WeekNum slicer, go to the Format tab, and click Change Interactions
Do the same for the Date Slicer
Screenshot_22.jpg


__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com

Hello,

Thanks.

 

Regards,

Chandrashekar B

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

April Fabric Community Update

Fabric Community Update - April 2024

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

March 2024 PBI Gallery Image

Power BI Monthly Update - March 2024

Check out the March 2024 Power BI update to learn about new features.

Top Solution Authors