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:...
Need Help
Tips and Tricks
Tutorial Requests
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:

     

     

    • mfaber's avatar
      mfaber
      Frequent Visitor
      9 years ago

      What's your Problem A Measure here?

       

      I'll answer your questions too, but I'd try this first :)

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

        mfaberI used this Measure for my example

         

        Problem A Measure =
IF (
    HASONEVALUE ( 'Table'[Project] ),
    CONCATENATEX ( 'Table', 'Table'[Problem A], ",", 'Table'[Problem A], ASC ),
    "Select a Project"
)

        Good Luck! :smileyhappy: