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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Mohd_Naim
Helper I
Helper I

Default row selected

I have problem situtaion where i need to show single row selected whenever report render firstime using table visual. 

examle:

I have 5 records in a table and want 1 row selected by default to show that perticular visual details into bar chart visual.

 

Please help to tackel this sinario.

2 REPLIES 2
v-lili6-msft
Community Support
Community Support

hi @Mohd_Naim 

Now when you log out of Power BI and come back to a report, the same items will be selected as when you left. For those who're looking to have a 'last month' selection, the relative date slicer might help.

 

and you could also try another workaround as amitchandak's said.

 

Regards,

Lin

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

@Mohd_Naim , There is no way to get a row selected. Also, the default slicer is hard coded values. Or you have to create something like this a get value selected

 

example for the month in a slicer

Month Type = Switch( True(),
Date([Date]) = eomonth(Today(),-1),"Last Month" ,
Date([Date])= eomonth(Today(),0),"This Month" ,
format([date],"YYYY-MM")
)

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors