Forum Discussion
Display selected slicer values(multiselect)
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
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
Thanks for looking into it.
But the ask here is to display the selected values in the slicer. I have created variable called selection, this is getting restricted to the data thats available but not just showing what has been selected.
Hope the issue is clear now, im sorry if i didnt explain my issue properly earlier.
