Forum Discussion

rhett_h1983's avatar
rhett_h1983
Regular Visitor
6 months ago
Solved

Help with slicer

Hi all.   I tried googling this, but I may not be phrasing it correctly.   Basically, I'm trying to add a slicer that will highlight age buckets. For example: 1-10 11-30 30-45 45-60 500...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 months ago

    Hi,

    If that is the raw data, then you need to use the "Unpivot" feature to reshape the data in which all buckets appear in a single column. 

  • v-ssriganesh's avatar
    v-ssriganesh
    6 months ago

    Hello rhett_h1983,
    I reproduced your scenario by creating a slicer-only helper table (using Reference + Unpivot) to expose the bucket names, linked it back to the original data and confirmed that the slicer correctly filters the totals without impacting existing visuals.

    For your reference, I’ve attached a .pbix file demonstrating this working end-to-end and thanks, danextian & Ashish_Mathur for sharing valuable insights.

    Best regards,
    Ganesh Singamshetty

v-ssriganesh's avatar
v-ssriganesh
Community Support
6 months ago

Hello rhett_h1983, 

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

 

Thank you for being part of the Microsoft Fabric Community.