Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
prashant_ora
Helper II
Helper II

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.
1 REPLY 1
v-jiascu-msft
Microsoft Employee
Microsoft Employee

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.