Forum Discussion

prashant_ora's avatar
prashant_ora
Icon for Helper II rankHelper II
8 years ago

Default value of slicer using database

Hi,

 

  • In my case i am having one table is having country
  • other table is having user and country mapping (One user is having more than one country)
  • one table is having user and default country
  • Now my requirment is when i use country slicer, it should show all the country(that is solved),but out of those country the default one should be selected which is avilable in my user and default country table. 
  • Please suggest.
Need Help

1 Reply

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi prashant_ora,

     

    Can you share some sample data please? The dummy pbix file would be great? 

    Questions:

    1. Where will be the default one? In the slicer? In other visuals?

    2. The slicer is for people to select. How to set a default one?

     

    Best Regards,

    Dale