Report Header formating with variable.

[ppgandhi11]

Hi, I want to print below in my report header:

Dashboard as of <Today's date>

Report from: <From Date> to: <ToDate>

When I use card visualization and try to use concate function since I have variables in the header, then I cannot format the header with different fonts, colors etc. They are pretty much what it comes with card visualization.

When I use textbox then I dont see a way to put the variables info. Textbox text can be formatted with choice of colors and fonts etc but without variable usage (so pretty standard fixed text can be written in it, as i see it).

How can I achieve this? I am sure power bi allows such things. Thanks! Prashant-

[ChrisMendoza]

hello @ppgandhi11,

Maybe something like this, at least for a data card visual...

Date Range = "Today is "&TODAY()&" "&"Report From: "&FORMAT([DateFirst],"mmm yyyy")&"-"&FORMAT([DateLast],"mmm yyyy") 

It displays in one line however. I would prefer a line break as I am sure you would.

[ppgandhi11]

Thanks Dozer. The problem is not in formula. The problem is in formatting (size, font, color). How would I control that in what you sent me (card visual)?

My measure is as below:

TitleOverview = CONCATENATE("Dashboard as of ", TODAY())

This measure is used in the card visual. However the card visual does not allow the text to be formatted. I want to change its font, color, size etc. Hope this helps.

[ChrisMendoza]

So the format tab does not provide enough customization for you? I do not know how to change the font, color, or size other than what is available in the format tab.

[ppgandhi111]

How can I make Date Range in your example invisible? I don't want that appear. Can you please let me know? Thanks!

[ChrisMendoza · Accepted solution]

The label 'Date Range' in gray? That's a Category Label under the Format tab. You can just toggle that On/Off as well as change font, size, & color.

[ppgandhi11]

Thanks. This is what I was looking for.

[ppgandhi11]

Resizing the overall control chops off the Date range value as well.