• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Matrix Visual with multiple columns based on slicer

prasaddn

Active Member
Hi All,
I am using a matrix visual on powerbi dashboard. my Final Matrix Layout is as follows:

Columns:
Baseline_MonthPerf (e.g., PrevBaseline, Month 1, Month 2)

Rows:
Asset Type
Service Type
Project Category
Request Type
Project Complexity
(No header, but column with metric names)

Values:
TATMeasure
VolumeMeasure
IterationMeasure
EffortMeasure

I would like to show a uni-direction slicer or buttons with words like "1 AssetType" ">> 2 Service Type" ">>3. Project Category" "4. >>Request Type". Something like deep-diving into the analysis, as the TAT, Iterations, Efforts differ by service type, project complexity etc.

I want make my matrix to show above Measures in values first at AssetType level.
if the user clicks ">> 2 Service Type", I want to show column Service Type. obviously the values will be now at service type level.
likewise if user clicks >>3. Project Category", I want to show column Project Category, and again te metrics TAT, Volume etc will be now at project category level, and so on.

I believe this can be done with bookmark, however, want to know if any other better and easier way to acheive this?
I tried FieldParameters with name MatrixHierarchy, placed this measure in rows by replacing all above said fields. However, with this Field Parameter slicer only one column is displayed in rows of matrix, and not multi selected columns

Is my requirements possible to acheive?
 
Back
Top