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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.