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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
mng
Helper I
Helper I

Report Builder - Conditional Border for each text box in calendar format

Hi, I'm trying to replicate an existing feature on a report but I think my understanding of using parameters is hindering me from this replication.  This feature creates a border around textboxes based on a condition. 

 

I actually wrote a lot of information that I'm afraid will just confuse folks, so i'll just ask and if its not clear still, I'd be happy to provide more information. 

 

Does anyone know how the variables "StartDay and "SwitchDays" would be designed in the report? I understand the logic of the expressions I just don't understand how to build this on the backend. 

 

img1 - calander.png

2 REPLIES 2
d_gosbell
Super User
Super User


@mng wrote:

Does anyone know how the variables "StartDay and "SwitchDays" would be designed in the report? 


What do you mean by "designed"? Are you asking how you manually add parameters to a report? If so you can do this by right-clicking on the parameters folder and choosing the add parameter option

d_gosbell_0-1698016075771.png

 

I just realized this is probably an SQL question, not sure why that didn't hit me before. 

 

My "how to design" question was to get help understanding how the query would be written for the parameters in the calendar tables. 

The parameter would be set from a column of dates but I'm struggling on how to set essentially 3 variables in sql using that column of dates for those 3 calendar months in report builder to create those borders around the dates. 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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

Top Solution Authors