Forum Discussion
Slicer
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.
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=asallproducts-allversions#limitations
1 Reply
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=asallproducts-allversions#limitations