Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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:
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
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.
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🤔
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
14 | |
5 | |
5 | |
4 | |
4 |