Forum Discussion

cqygfxgf's avatar
cqygfxgf
Frequent Visitor
2 years ago

Field Parameter column hierarchy

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! 

Need Help
Tips and Tricks
Tutorial Requests

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    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