Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Need help with power bi report display data

Hi   Is there any way we can show our power bi data in the below format     Any help would be appreciated Thanks  
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Arul's avatar
    Arul
    4 years ago

    Anonymous ,

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

    Thanks,

    Arul

  • Shishir22's avatar
    Shishir22
    4 years ago

    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.

     

Shishir22's avatar
Shishir22
Icon for Solution Sage rankSolution Sage
4 years ago

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.

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.

  • Shishir22's avatar
    Shishir22
    Icon for Solution Sage rankSolution Sage
    4 years ago

    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"

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      hi Shishir22 

       

      still not working, appearing in 1 line only.

      any other solution that may work

       

      Thanks

      • Shishir22's avatar
        Shishir22
        Icon for Solution Sage rankSolution Sage
        4 years ago

        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.