Field Parameter column hierarchy

[cqygfxgf]

Hi, I'm wondering if anyone can help me here with multiple field parameters in a matrix.

I'm creating 2 field parameters to introduce slicers for users to custermize the report.

One fore the reporting measures:

One for the time intelligence:

When I put both parameters in a matrix, I expect it to create a hierachy where time intelligence is under the main KPIs, so the user can drill down. But instead I'm getting a flat table with the columns next to each other:

I know we can use calculation groups for this, but I would lost the ability to conditionally format on row level (like background the Decemeber data even if it's empty).

Anyone has an idea how to achieve this? Thanks! 

[amitchandak]

@cqygfxgf , I think for what you trying, you need to use calculation group  with items like

Assume you sales and quantity as measure

CM = calculate(selectedmeasure(), datesmtd(Date[Date]) )

PM = calculate(selectedmeasure(), datesmtd(Dateadd(Date[Date],-1,month) ) )

MOM = divide(calculate(selectedmeasure(), datesmtd(Date[Date]) ) - calculate(selectedmeasure(), datesmtd(Dateadd(Date[Date],-1,month) )) , calculate(selectedmeasure(), datesmtd(Dateadd(Date[Date],-1,month) )))

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

Learn Power BI: Model explorer public preview with calculation group authoring| Measure Slicer: https://youtu.be/VfxfJJ0RzvU