Forum Discussion

MahsaTMahsa's avatar
MahsaTMahsa
Frequent Visitor
2 years ago

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: First Slicer: Contains text values ...
" Slicer"
"Need Help"
"Table"
hackcrr's avatar
hackcrr
Icon for Memorable Member rankMemorable Member
2 years ago

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