Forum Discussion

ergocorp's avatar
ergocorp
Helper II
3 years ago
Solved

Dynamic Coloured Shapes

Hi there, Im trying to build a mock of a report, so please ignore some of the formatting.   I have manually coloured and set the directions of those arrows, but those are for the totals. The ...
Need Help
  • VijayP's avatar
    VijayP
    3 years ago

    ergocorp 

    With IF condition you can create a measure

    if( this value < that value ,UNICHAR(123456) ,Unichar(132345)) just example

    all unichar values available in this link https://www.vertex42.com/ExcelTips/unicode-symbols.html

    you can use a card and use Title and in the title you can add this measure

     

  • VijayP's avatar
    VijayP
    3 years ago

    ergocorp  you have different coloured shapes check them! and share your Kudos and if it is your soltuion Mark this as solution!

ergocorp's avatar
ergocorp
Helper II
3 years ago

Thanks, 

 

You've given me a couple of questions though.

 

1. Conditional Measures. I think that would be a create measure, can i just google how to set that up?

2. Once i have done that, which visualisation would I use to display it?

3. I've never used unichar() is that a DAX expression?

 

Thanks

 

  • VijayP's avatar
    VijayP
    Community Champion
    3 years ago

    ergocorp 

    With IF condition you can create a measure

    if( this value < that value ,UNICHAR(123456) ,Unichar(132345)) just example

    all unichar values available in this link https://www.vertex42.com/ExcelTips/unicode-symbols.html

    you can use a card and use Title and in the title you can add this measure

     

    • ergocorp's avatar
      ergocorp
      Helper II
      3 years ago

      Excellent, I have that working. The next query is around colour. Can I add that in do you know?

      • VijayP's avatar
        VijayP
        Community Champion
        3 years ago

        ergocorp  you have different coloured shapes check them! and share your Kudos and if it is your soltuion Mark this as solution!