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
Anonymous
Not applicable

Need help with power bi report display data

Hi

 

Is there any way we can show our power bi data in the below format

 

Usinghal_0-1653303213419.png

 

Any help would be appreciated

Thanks

 

2 ACCEPTED SOLUTIONS
Arul
Super User
Super User

@Anonymous ,

you can create one table manually and then show these values in Multi row card.

Thanks,

Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


View solution in original post

Shishir22
Solution Sage
Solution Sage

Hello @Anonymous ,

 

I am assuming all these numbers are measures you created. You can concatenate the measures and move to next line using UNICHAR(10) and show it in card visual.


Also you can use UNICHAR(129182) for adding a dot symbol in starting.

 

Try something as -

Measure =
UNICHAR(129182)&" "&[TotalMeasure]&" -Total"&UNICHAR(10)
UNICHAR(129182)&" "&[UniqueHeadMeasure]&" -Unique Head"&UNICHAR(10)
UNICHAR(129182)&" "&[TrainingMeasure]&" Hrs-Training"&UNICHAR(10)
UNICHAR(129182)&" "&[TotalTrainingMeasure]&" -Total Training"

 

Please mark it as answer if it resolves your issue. Kudos are also appreciated.

 

Cheers,
Shishir

View solution in original post

7 REPLIES 7
Shishir22
Solution Sage
Solution Sage

Hello @Anonymous ,

 

I am assuming all these numbers are measures you created. You can concatenate the measures and move to next line using UNICHAR(10) and show it in card visual.


Also you can use UNICHAR(129182) for adding a dot symbol in starting.

 

Try something as -

Measure =
UNICHAR(129182)&" "&[TotalMeasure]&" -Total"&UNICHAR(10)
UNICHAR(129182)&" "&[UniqueHeadMeasure]&" -Unique Head"&UNICHAR(10)
UNICHAR(129182)&" "&[TrainingMeasure]&" Hrs-Training"&UNICHAR(10)
UNICHAR(129182)&" "&[TotalTrainingMeasure]&" -Total Training"

 

Please mark it as answer if it resolves your issue. Kudos are also appreciated.

 

Cheers,
Shishir
Anonymous
Not applicable

Hi @Shishir22 

 

unichar(10) is not adding line break to the measure

So is there any other way we can add line break in this.

Sorry, use this -

 

Measure =
UNICHAR(129182)&" "&[TotalMeasure]&" -Total"&UNICHAR(10)&
UNICHAR(129182)&" "&[UniqueHeadMeasure]&" -Unique Head"&UNICHAR(10)&
UNICHAR(129182)&" "&[TrainingMeasure]&" Hrs-Training"&UNICHAR(10)&
UNICHAR(129182)&" "&[TotalTrainingMeasure]&" -Total Training"

 

Cheers,
Shishir
Anonymous
Not applicable

hi @Shishir22 

 

still not working, appearing in 1 line only.

any other solution that may work

 

Thanks

Unichar(10) is working fine for me.
I hope you are creating a measure and putting that in card.  It is giving expected result for me.

Refer below screenshot.

 

Shishir22_0-1653316810666.png

 

Cheers,
Shishir
Anonymous
Not applicable

Hi @Shishir22 

 

yeah it is working fine now, 

Thanks

 

Arul
Super User
Super User

@Anonymous ,

you can create one table manually and then show these values in Multi row card.

Thanks,

Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


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.

Top Solution Authors