Forum Discussion

BIswajit_Das's avatar
BIswajit_Das
Impactful Individual
1 month ago

Measure Based Slicer

Dynamic Measure-Based Slicer for Power BI

MeasureSlicer 

One of the current limitations of Power BI is that slicers can only be built from columns, while many business scenarios require slicing based on measure results.

Proposed Custom Visual

The visual would accept the following fields:

  • Grouping Column (e.g., AC_NO, Customer ID, Product ID)

  • Measure (returns the category/value to be displayed)

  • Tooltips (optional)

Internally, the visual would evaluate the measure for every unique value of the grouping column, generating a temporary table similar to:

Grouping Column Measure Result

AC_001AAP
AC_002BJP
AC_003AAP
AC_004INC

The slicer would then display only the distinct measure results:

  • AAP

  • BJP

  • INC

When a user selects AAP, the visual would filter all grouping values whose evaluated measure result is AAP, enabling native cross-filtering and interaction with other visuals.

Why This Matters

This approach enables a fully dynamic slicer where the available selections are determined by DAX measures rather than static columns. As report filters, slicers, or calculations change, the measure is re-evaluated and the slicer updates automatically.

Benefits

  • Supports dynamic, measure-driven slicers.

  • Eliminates the need for helper or calculated columns created only for filtering.

  • Works with complex business logic implemented in DAX.

  • Responds automatically to filter context.

  • Enables analytical scenarios that are not possible with native Power BI slicers.

This custom visual would close a long-standing gap in Power BI by allowing measures to act as slicer categories while preserving the native filtering experience.


The custom visual: MeasureSlicer 
 
Thanks & Regards 
Biswajit Das.

Interesting Links
Show and Tell

5 Replies

  • MFelix's avatar
    MFelix
    Super User
    1 month ago

    Hi  BIswajit_Das ,

     

    I have made some experiments, with your visual and it performs good, not sure how would perform with large semantic models that would result in millions of rows but so far so good.

     

    Also really like the customization options that you have and the overall look and feel.

     

    My advise is for you to try and submit this to the appsource for sure you will get a lot of traction usually when there are new visuals they are higlithed in the Power BI Desktop release for that month, and maybe MSFT will also include it in their to do list.

  • v-abhinavmu's avatar
    v-abhinavmu
    Community Support
    1 month ago

    Hi BIswajit_Das,

    Thank you for taking the time to share this well-thought-out idea. Enabling slicers based on measure results could provide greater flexibility for many reporting scenarios.

     

    Please consider posting your proposal in the Power BI Ideas forum:

    Fabric Ideas - Microsoft Fabric Community

     

    The product team actively reviews ideas submitted there, and suggestions with strong community support are more likely to be considered for future implementation. Posting your idea there also allows other community members to vote and provide feedback.

     

    I hope this helps. Please feel free to reach out if you have any further questions.
    Thank you.

  • v-abhinavmu's avatar
    v-abhinavmu
    Community Support
    1 month ago

    Hi BIswajit_Das,

     

    Could you please confirm if you've submitted this as an idea in the Ideas Forum? If so, sharing the link here would be helpful for other community members who may have similar feedback.

     

    Thank you.