topic Need Help Adding Text Slicer to Table in Power BI in Report Server

Need Help Adding Text Slicer to Table in Power BI

MahsaTMahsa — Tue, 02 Jul 2024 07:29:39 GMT

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
Second Slicer: Contains numeric values (this slicer is set up correctly and works fine)
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 much

Re: Need Help Adding Text Slicer to Table in Power BI

hackcrr — Wed, 03 Jul 2024 00:02:16 GMT

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

Re: Need Help Adding Text Slicer to Table in Power BI

MahsaTMahsa — Tue, 09 Jul 2024 05:26:39 GMT

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🤔

Re: Need Help Adding Text Slicer to Table in Power BI

Anonymous — Wed, 31 Jul 2024 08:20:18 GMT

Hello,hackcrr ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.
Hi,MahsaTMahsa I am glad to help you.

According to your description, you want to realize that when clicking on the slicer the selected option is added as a column to the viusal

For the text slicer you can try to add the field parameter.

URL:
Use parameters to visualize variables - Power BI | Microsoft Learn

To add it as a slicer, you may need to rework your previous MEASURES a bit because the filtering conditions have changed.

I've uploaded the pbix file I used for testing, hope this helps.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.