cancel
Showing results for 
Search instead for 
Did you mean: 
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

Regards,
Arul
If I answered your question kindly mark my post as a solution and a kudo would be appreciated.

View solution in original post

Shishir22
Super User
Super User

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
Super User
Super User

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

Regards,
Arul
If I answered your question kindly mark my post as a solution and a kudo would be appreciated.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors