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: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
RAHULBANDI
Helper II
Helper II

Column Header for Table/ Matrix

‎09-15-2022 09:33 PM

Hi Friends I have Following Datasets

requirements: 

1)  Format of the data 

RAHULBANDI_0-1663302439835.png

 

2. Add 2 slicers on the same page – “Top Customers” slicer and “Date Range” slicer

 

Top Customers – This slicer contains 3 values – [Top 10, Top 20, Top 30].
If someone clicks on Top 10, only those Customers should get filtered whose Total amount (Offline + Online combined) is falling in Top 10 (by descending order).
Similarly, if Top 20 is clicked, then top 20 customers by total amount should be filtered, etc.

Date Slicer – Create a Date range slicer based on the sale date

 

Expected Result:

 

RAHULBANDI_1-1663302548783.png

Additional screenshot:

--If someone clicks on “Top 10” in the Top Customers slicer, then, only Top 10 customers by Total Amount should be filtered as shown in the below screenshot

 

 

 

 

 

Labels:
Message 1 of 3
331 Views
0
2 REPLIES 2
v-henryk-mstf
Community Support
Community Support

‎09-19-2022 02:35 AM

Hi @RAHULBANDI ,

 

After testing, the data you provided seems to be problematic and does not yield the expected results, can you explain further?


Looking forward to your reply.


Best Regards,
Henry

 

Message 3 of 3
266 Views
0
RAHULBANDI
Helper II
Helper II

‎09-15-2022 09:35 PM

Data-set for the above scenario:

 

Sale DateType of SaleCustomer NameSale AmountUnits Purchased
1-Jan-22OnlineCustomer19258153
1-Jan-22OnlineCustomer222933173
1-Jan-22OnlineCustomer3310909120
1-Jan-22OnlineCustomer373247155
1-Jan-22OnlineCustomer671747197
1-Jan-22OnlineCustomer676217159
1-Jan-22OnlineCustomer681435102
1-Jan-22OfflineCustomer684967135
1-Jan-22OnlineCustomer83500184
2-Jan-22OfflineCustomer135657113
2-Jan-22OnlineCustomer355180113
2-Jan-22OnlineCustomer515614167
2-Jan-22OnlineCustomer532379155
2-Jan-22OfflineCustomer692294122
2-Jan-22OnlineCustomer698405149
2-Jan-22OfflineCustomer694520102
2-Jan-22OfflineCustomer6917307147
2-Jan-22OnlineCustomer69920170
2-Jan-22OfflineCustomer692909177
3-Jan-22OnlineCustomer4655536115
3-Jan-22OnlineCustomer534280129
3-Jan-22OfflineCustomer559644116
3-Jan-22OfflineCustomer703377185
3-Jan-22OnlineCustomer7012737162
3-Jan-22OnlineCustomer701817139
3-Jan-22OnlineCustomer706497194
3-Jan-22OnlineCustomer71749160
3-Jan-22OnlineCustomer712226132
4-Jan-22OfflineCustomer454180150
4-Jan-22OfflineCustomer494814148
4-Jan-22OfflineCustomer513857166
5-Jan-22OnlineCustomer254363124
5-Jan-22OfflineCustomer4612695182
5-Jan-22OnlineCustomer175962115
5-Jan-22OfflineCustomer173043172
6-Jan-22OnlineCustomer261870166
6-Jan-22OfflineCustomer303610141
6-Jan-22OnlineCustomer4614076171
6-Jan-22OnlineCustomer481571199
6-Jan-22OfflineCustomer58341194
6-Jan-22OnlineCustomer5065174192
7-Jan-22OnlineCustomer348741153
7-Jan-22OfflineCustomer372823158
7-Jan-22OnlineCustomer4614076118
7-Jan-22OnlineCustomer63358164
8-Jan-22OfflineCustomer2025996113
8-Jan-22OnlineCustomer2810494126
8-Jan-22OnlineCustomer355547195
8-Jan-22OnlineCustomer537075135
8-Jan-22OfflineCustomer559644164
8-Jan-22OfflineCustomer94330196
9-Jan-22OfflineCustomer125174118
9-Jan-22OfflineCustomer1220193126
9-Jan-22OnlineCustomer155296113
9-Jan-22OnlineCustomer235353186
9-Jan-22OnlineCustomer5615309149
Message 2 of 3
329 Views
0

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 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
Top Solution Authors
View All