Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Variable values fields required in column chart

Hi, I want to have variable value fields in column chart instead of fixing them. For example, I have overtime data of cost and hrs.   I want to create ONE single clustered column chart where month...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, Anonymous 

     

    You may create a table and a measure as below.
    Table:

     

    Measure:

Result = 
IF(
    ISFILTERED('Table'[Category]),
    IF(
        SELECTEDVALUE('Table'[Category])="Cost",
        SUM(Overtime[Overtime Cost]),
        IF(
            SELECTEDVALUE('Table'[Category])="Hrs",
            SUM('Overtime'[Overtime Hrs])
        )
    )
)

     

    Result:

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, Anonymous 

 

You may create a table and a measure as below.
Table:

 

Measure:

Result = 
IF(
    ISFILTERED('Table'[Category]),
    IF(
        SELECTEDVALUE('Table'[Category])="Cost",
        SUM(Overtime[Overtime Cost]),
        IF(
            SELECTEDVALUE('Table'[Category])="Hrs",
            SUM('Overtime'[Overtime Hrs])
        )
    )
)

 

Result:

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.