Filtering Calculated Columns

[mollig3]

I have created a mess of calculated columns that will show three lines when selected as "line values" on the graph. Here is an example of the calculated columns:

 FP Capacity 8 Hours

FP Capacity 10 Hours

 FP Capacity 12 Hours

Meat Capacity 8 Hours

Meat Capacity 10 Hours

Meat Capacity 12 Hours

I have a slicer on my dashboard from a different field that contains:

FP

Meat

What I'm wanting is that when the user selects "FP" from the slicer, the combo chart will automatically graph the three Capacity calculated columns from above that say FP in the title.

Thanks in advance for the help 🙂

[v-juanli-msft · Accepted solution]

Hi @mollig3

Not like measures, calculate columns are computed during database processing and then stored in the model, they do not response to user selections on the report.

So it is not possible to create a calculate column to change dynamically with user selections on the report.

Normally, we can create measures instead, then show the measures on the visual with the corresponding columns from your table.

For example,

FP Capacity 10 Hours =
IF ( SELECTEDVALUE ( Table5[TYPE] ) = "FP", MAX ( [FP Capacity 10 Hours2] ) )

Meat Capacity 10 Hours = IF(SELECTEDVALUE(Table5[TYPE])="Meat",MAX([Meat Capacity 10 Hours2]))

Best Regards

Maggie