Forum Discussion

3508026's avatar
3508026
Icon for Helper II rankHelper II
7 months ago
Solved

Slicer for filtering several columns

Hello, I need to create slicer for filtering the data that are in different columns: - Slicer for filtering the view: The optiona are in different columns. - Slicer for filtering the metric: The o...
Need Help
  • hnguy71's avatar
    hnguy71
    7 months ago

    Hi 3508026 

    Yes, you can use field parameters. Although, not really ideal but it's possible.

     

    1. On the ribbon bar, under MODELING select 'New Parameter' and then select 'Fields'

       

    2. Create a name for your parameter, for example, 'View' and add all the fields you want to be part of that parameter.
    3. Repeat for as many different parameters you may need or have. Then, if you don't have 'View Hidden' on your model enabled already, for each of those new parameters, right click the table, and click 'View Hidden'

       

    4. Finally, drop the 'Fields' column to any of your visual(s).

     

     

    I have attached a sample pbix file for you:

v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
7 months ago

Hi 3508026,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Thank you FBergamaschi and hnguy71 for the prompt response.

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa

  • v-achippa's avatar
    v-achippa
    Icon for Community Support rankCommunity Support
    7 months ago

    Hi @3508026,

     

    We wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

     

    Thanks and regards,

    Anjan Kumar Chippa