Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by watching the DP-600 session on-demand now through April 28th.
Learn moreJoin the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now
Good afternoon, everybody.
Imagine that I have a simple dashboard with this sheet that I paint for you.
(it's a simple drawing)
What I want is that if you filter on Single Value DataSegmentation, all visuals (Gantt Chart, Matrix, Bar Chart, and KPI Card) change and show me the information for that selected data in the slicer. But if I select two or more (or none), the visuals do not display data and appear blank.
It's possible? I'd been through "iscrossfiltered" or type functions, but I don't know if it's going to work.
Thank you all!
Solved! Go to Solution.
Hi @Syndicate_Admin ,
It depends on the data model and the measure used to create it. I did the test for reference as follows. Can successfully select multiple results through the slicer, but I created a measure to obtain the name value under the corresponding date. When the slicer selects multiple results, the result is blank:
Measure = SELECTEDVALUE('Table (2)'[Name])
If the problem is still not resolved, please provide a detailed data model and the created dax formula. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Syndicate_Admin ,
It depends on the data model and the measure used to create it. I did the test for reference as follows. Can successfully select multiple results through the slicer, but I created a measure to obtain the name value under the corresponding date. When the slicer selects multiple results, the result is blank:
Measure = SELECTEDVALUE('Table (2)'[Name])
If the problem is still not resolved, please provide a detailed data model and the created dax formula. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Syndicate_Admin it all depends on how your tables are connected and what measure you are using. It is weird by selecting more than one value it will show blank. The information you provided is not enough to provide any recommendations.
Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Check out the April 2026 Power BI update to learn about new features.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 41 | |
| 37 | |
| 34 | |
| 21 | |
| 16 |
| User | Count |
|---|---|
| 64 | |
| 58 | |
| 31 | |
| 25 | |
| 25 |