Slicer

[Vladan]

Hi everyone,

This is the sample of my data. I have a chart with positive values and two slicers. One slicer has Parameter column in field, and the other with YTD/QTD column. Second slicer is needed to show QTD and YTD data for P&L, but that prevents chart from showing data when BS category is selected. Is there a way to keep both slicer, but make second one inactive when BS category is selected?

Here is how my layout looks.

[amitchandak · Accepted solution]

@Vladan , Not very clear. But I think the calculation group can help

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

tabular - Calculation groups
https://docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallprodu...