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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Scottpaper
Regular Visitor

Carriage return not working in measure in Power BI report server (March version)

Hi,

 

I have an issue with a measure I created to display the active filters. In the report, the measure is displayed in a card. I split each active filters with a carriage return and I do so by using UNICHAR(10). It works in Power BI Desktop, but when I upload the file in report server, it does not work anymore. 

 

Here is the measure: 

_Active filters_ =
"Filters Applied:"
&IF(ISFILTERED(Query1[Portfolio Name Level 2]),
UNICHAR(10)&"- Portfolio Name Level 2: "& FILTERS(Query1[Portfolio Name Level 2]),"")
&IF(ISFILTERED(Query1[Portfolio Name Level 3]),
UNICHAR(10)&"- Portfolio Name Level 3: "& FILTERS(Query1[Portfolio Name Level 3]),"")
&IF(ISFILTERED(Query1[Portfolio Name Level 4]),
UNICHAR(10)&"- Portfolio Name Level 4: "& FILTERS(Query1[Portfolio Name Level 4]),"")
&IF(ISFILTERED(Query1[Extended Issuer]),
UNICHAR(10)&"- Extended Issuer: "& FILTERS(Query1[Extended Issuer]),"") 

 

Thank you for helping me. I am open to suggestions where I can accomplish the same thing, but with a different visual.

1 REPLY 1
Giavo
Helper III
Helper III

Hi, same happened to me today. Did you manage to solve this issue ?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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