cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Usinghal
Helper I
Helper I

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

@Usinghal ,

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

Thanks,

Arul

Arul

View solution in original post

Shishir22
Super User
Super User

Hello @Usinghal ,

 

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 @Usinghal ,

 

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

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

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

Hi @Shishir22 

 

yeah it is working fine now, 

Thanks

 

Arul
Super User
Super User

@Usinghal ,

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

Thanks,

Arul

Arul

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 25

Ted's Dev Camp - August 25, 2022

Watch Session 25 of Ted's Dev Camp.

Top Solution Authors