Forum Discussion

vijayvizzu's avatar
vijayvizzu
Icon for Helper III rankHelper III
5 years ago
Solved

Value along with Percentage value

Hi Is there a way to display both value and % value in a single card visual ?

Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    Hi vijayvizzu .

     

    Using a card visualization the only option would be to create a measure that woudl concatenate both of the values something similar to:

     

    Value + percentage =
SUM ( 'Table'[Value] ) & UNICHAR ( 10 ) -- unichar is used for line break
    & FORMAT (
        DIVIDE (
            SUM ( 'Table'[Value] ),
            CALCULATE ( SUM ( 'Table'[Value] ), ALL ( 'Table'[Cat] ) )
        ),
        "##,0%"
    )

     

     

1 Reply

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    5 years ago

    Hi vijayvizzu .

     

    Using a card visualization the only option would be to create a measure that woudl concatenate both of the values something similar to:

     

    Value + percentage =
SUM ( 'Table'[Value] ) & UNICHAR ( 10 ) -- unichar is used for line break
    & FORMAT (
        DIVIDE (
            SUM ( 'Table'[Value] ),
            CALCULATE ( SUM ( 'Table'[Value] ), ALL ( 'Table'[Cat] ) )
        ),
        "##,0%"
    )