Forum Discussion

Joe95's avatar
Joe95
New Member
6 months ago
Solved

Designing a True Executive Self-Service Report (Dynamic Columns & Hierarchies)

Hi Fabric Community, I’m currently designing a Power BI solution for the CEO of my company and I’m looking for architectural guidance and best practices from the community. Context The CEO is requ...
  • Natarajan_M's avatar
    6 months ago

    Hi Joe95  , You are in the right direction . 

    Make use of the field parameter create one field params for all the measures and one for the dimensions using this two and the matrix visual you can play arround with the diffrent combination of metrics and dimensions .

    Take an iterative apporach start with a simple template then based on the interation and user feedback refine the model and visuals 

    Keep the report interaction simple try to group your measures in the sense it should be intuitive 

    The C-level execs they would typically have access to all the data so no point in adding the security