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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
MahsaTMahsa
Frequent Visitor

Need Help Adding Text Slicer to Table in Power BI

Hi everyone,

I'm working on a project in Power BI and need a table that changes its values based on three different slicers. The slicers I need are as follows:

  1. First Slicer: Contains text values
  2. Second Slicer: Contains numeric values (this slicer is set up correctly and works fine)
  3. Third Slicer: Contains a set of measures written with a calculated group (this slicer is also set up correctly and works fine)

My problem is adding the first slicer to the table. I'm not sure how to add this text slicer to my table so that the values are filtered based on the selections from the text slicer.

Could anyone guide me on how to do this? Any advice or practical examples would be greatly appreciated.

Thank you very muchTable.jpg

2 REPLIES 2
MahsaTMahsa
Frequent Visitor

Hello

I made the time slicer with the Calculation Measure and there is no problem
My question now is for the text slicer, which includes categories, groups, etc. (the blue part in the picture)
I don't know how to make this part of the table dynamic with slicer🤔

hackcrr
Solution Sage
Solution Sage

Hi, @MahsaTMahsa 

You need to create a metric that is dynamically updated based on the slicer's selection. The following is an example of how to create such a metric:

SelectedMeasure = 
SWITCH(
    TRUE(),
    SELECTEDVALUE('Measure Slicer'[Measure]) = "Pre Month", [Pre Month Measure],
    SELECTEDVALUE('Measure Slicer'[Measure]) = "Pre Week", [Pre Week Measure],
    SELECTEDVALUE('Measure Slicer'[Measure]) = "Pre Year", [Pre Year Measure],
    SELECTEDVALUE('Measure Slicer'[Measure]) = "Pre Season", [Pre Season Measure]
)

Add it SelectedMeasure to your form visuals.This will ensure that the table is updated according to the selected measure in the third slicer.

Ensure that all slicers are set to interact with the table visuals. You can check and adjust this by selecting each slicer, going to the Format tab, and setting Edit Interaction to.

 

 

hackcrr

If this post helps, then please consider Accept it as the solution and kudos to this post to help the other members find it more quickly

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors