Dynamic Measure

[Anonymous]

I have created a dynamic measure, which is working as expected.

My issue/request/query is this.

I have placed the measure into a CARD visualisation, but all of the text the measure creates just goes in one line.

eg:

Yesterday Mike made 87 calls and Dave made 92. Those calls were from: 67 - Manchester; 82 - Swindon; 30 - Leeds.

I would like to arrange this so that it looks like this:

Yesterday Mike made 87 calls and Dave made 92. 

Those calls were from:

67 - Manchester;

82 - Swindon;

30 - Leeds.

I'm sure I'm missing something really easy but help from you awesome guys woiuld be very much appreciated.

[v-huizhn-msft · Accepted solution]

Hi @Anonymous,

Until now, we can not add line break in text directly, because Power BI always strips line breaks out of text when it gets loaded into the Data Model, please review the following feature requests and vote them.

allow line breaks
Automatically detect CR/newline characters while importing from text files

For your scenario, there are the following solutions, you can create multiple measures. 

Measure1 returns: Yesterday Mike made 87 calls and Dave made 92. 

Measure2 returns: Those calls were from:

Measure3 returns: 67 - Manchester;

Measure4 returns: 82 - Swindon;

Measure5 returns: 30 - Leeds.

Then you can put the mutiple measure in muti-row card, please see the screenshot, but there are still deficiency for using this card, you need to adjust it manually. Please review this idea.



Or you can create several card visualizations using different measures.


Best Regards,
Angelia

[Anonymous]

Hey Angelia,

Many thanks for that.

I have used the multiple measures option but will also review the feature requests and vote for one of them accordingly.

Have a great day.

A