Variable values fields required in column chart

[Anonymous]

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 should be in x-axis (fixed) and in values area I want variable values.

Like if I click on a button / slicer for overtime cost, the column chart should give me cost and if I select overtime Hrs, i t should show Hrs.

ONE CHART FOR TWO FIELDS (COST & HRS)

Please see my sample data and advise.

https://www.dropbox.com/sh/1zrdlchzcfmwzcs/AADAvy5zk9ifpzzFnImEVHfEa?dl=0

Regards,

Imran

[v-alq-msft · Accepted solution]

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.

[amitchandak]

@Anonymous , Refer if this can help

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115

[Anonymous]

I saw the post you share but actually this is not the case I am looking for. I need to have;

fix "x-axis" -- that is month, and;

variable "y-axis" --that is either cost or Hrs

Both cost and hrs are two seprate columns of my table. What is the solution of this problem.

Regards,