Forum Discussion
Display selected slicer values(multiselect)
Hi experts,
I have been searching for solution to my requirement since a couple of days but couldnt find one, hence creating this thread.
My requirement is just to display the values that are selected in a slicer(could be multi values as well).
I tried
Filters Selected =
IF (
ISFILTERED ( MyTable[MyColumn] ),
CONCATENATEX ( FILTERS ( MyTable[MyColumn] ), MyTable[MyColumn], ", " ),
"ALL"
)but the problem we are facing is, it displays the values only that has the data in my tables for that selected combination
for eg,
i have 2 slicers, year and Region. In my tables if I dont have data for this selected combination. My Filters Selected will show blank.
Is this expected behaviour? Or is there something that Im missing. Any suggestions pls...
Hi kpavan999 ,
As checked your sample file, you have created a one-to-many relationship between Table 1 and Table 2, with the filtering direction being single. And you are using the Region field of table 1 as a slicer option, the region of table 1 only have APJ and NA. Only the relevant data with selected year and these two regions will be displayed in table visual in case the region slicer using the Region field of table 1 does not select any region. If you want to display data about all the regions in Table 2 in the table visual, place the region field in Table 2 as the first field of table visual. Select the table visual, then in the Values fields well, right-click the field and select Show items with no data from the menu that appears, as shown in the following image:
Best Regards
8 Replies
Do you get solution for this issue, I meet same problem. Please share the resolution if any, thanks.
Hi kpavan999
Can you try below code:-
Measure = CONCATENATEX ( VALUES ( 'Table'[Column] ) , [Column] , ",")Thank you,
Samarth
Samarth_18, yes I tried this too but no luck 😞
kpavan999 , Is it possible for you to share PBIX file? You can delete your sensitive data and share what is enough to to check your issue.
I have shared here, Can someone pls check and let me know if this is the expectation of the functionality of If im doing something wrong.
Thanks in advance.
https://drive.google.com/file/d/1LWCVw3ewNsF0Bz5GlKOed8ZLLhoJ66Y4/view?usp=sharing
Hi kpavan999 ,
As checked your sample file, you have created a one-to-many relationship between Table 1 and Table 2, with the filtering direction being single. And you are using the Region field of table 1 as a slicer option, the region of table 1 only have APJ and NA. Only the relevant data with selected year and these two regions will be displayed in table visual in case the region slicer using the Region field of table 1 does not select any region. If you want to display data about all the regions in Table 2 in the table visual, place the region field in Table 2 as the first field of table visual. Select the table visual, then in the Values fields well, right-click the field and select Show items with no data from the menu that appears, as shown in the following image:
Best Regards
Hi kpavan999 ,
Could you please share some sample data(exclude sensitive data) and your expected result with backend logic and special examples in order to provide you a suitable solution? Do you want to display the text with "2015-FY, APJ" on your visual if you selected the values in below 2 slicers? By the way, do the field [Year] and [Region Level 1] come from the same table? Thank you.
In addition, please review the content in the following links. Hope they can give you some clue or insight.
Display selected slicers in Power BI
Creating a slicer that filters multiple columns in Power BI
Best Regards
