Forum Discussion

mfaber's avatar
mfaber
Frequent Visitor
9 years ago

Highlighting and wrap text in multirow card

Hi!

 

I'd like to visualize different problems occured during a store visit. I have 4 different problem categories, each one has a different column in the data field. So I'd like to show Problem A: xyzxyz... happened, Problem B: abcd happened, etc..

I did it like this:

 

 

 

 

 

 

 

 

 

 

 

 

First problem: Is it possible to highlight a row or the text when there's an actual problem, or to lowlight ( is this a real word?:smileyhappy: ) when there's no problem?

 

Second problem: Is it possible to visualize Problem A somehow nicer, so we can see the whole text? As far as I know there's no direct "wrap text" in power bi yet, but any workaround maybe?

 

I'm also open to other visuals if you have a better idea.

 

Thank you!

 

Need Help
Tips and Tricks
Tutorial Requests

7 Replies

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    9 years ago

    mfaber

     

    To get this kind of flexibility try the Card with States Custom Visual (and create 3 Cards in your case)

     

    To read/learn more about it go here

     

    You can also download it from here

     

    Hope this helps.

    Good Luck! :smileyhappy:

    • mfaber's avatar
      mfaber
      Frequent Visitor
      9 years ago

      Hey, thanks for the quick answer!

       

      Cards are just for numbers, aren't they?

      I need to show texts, to see what's the problem. It counts the texts for me.

      What am I doing wrong?

       

      I'm still trying to figure it out, but no luck yet. Sorry, I'm pretty new to this.. :smileyhappy:

       

      • Sean's avatar
        Sean
        Icon for Community Champion rankCommunity Champion
        9 years ago

        How long is the text in these columns???

         

        And to channel MattAllington - I don't know if this is the best way to setup you data? (from the little I can gather)

        http://exceleratorbi.com.au/shaping-modelling-power-bi/

         

        But to answer you question yes you can use TEXT but you'll have to use a Measure to display it

        As you can see you'll also need Color Columns for each so you can use them to determine the state of each card...

        That's why you may have to re-shape your data

         

        Good Luck! :smileyhappy:

         

         

  • XMonsterX's avatar
    XMonsterX
    Icon for Advocate II rankAdvocate II
    9 years ago

    This may not apply to most people, as I was just trying to get a table to show my relevant text and wrap it, based on my selection. 

     

    I tested a bunch of different visualizations, etc. 

    I was only able to wrap my text in my box with one of the visualizations. Cards  (Little square with 123) did it for me.

     

    Once you've selected the data you want in your card, go to the format section and turn on "Word Wrap".


    Hope this helps. 

    Not sure what version I'm on as it's a work account.

    David