Forum Discussion
Single selection data segmentation
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!
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.
2 Replies
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/38490Hi 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.
