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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Selded
Helper III
Helper III

Custom Title using Measures

I want the below title 

18 of 30 Working Days, but my measure is giving the below. how do i introduce a space.

 

Counting Days = [Days_Worked_In_Current_Month] & "of" & [Days_In_Current_Month] & "Working Days"

18of30Working Days

 

 

1 ACCEPTED SOLUTION
jppv20
Solution Sage
Solution Sage

Hi @Selded ,

 

Try this:

Counting Days = [Days_Worked_In_Current_Month] & " of " & [Days_In_Current_Month] & " Working Days"
 
(Putting a space in the beginning and end of " of " and at the beginning of " Working Days"
 
Jori
 
If I answered your question, please mark it as a solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
jppv20
Solution Sage
Solution Sage

Hi @Selded ,

 

Try this:

Counting Days = [Days_Worked_In_Current_Month] & " of " & [Days_In_Current_Month] & " Working Days"
 
(Putting a space in the beginning and end of " of " and at the beginning of " Working Days"
 
Jori
 
If I answered your question, please mark it as a solution to help other members find it more quickly.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.