Forum Discussion

Arshadjehan's avatar
Arshadjehan
Helper I
6 years ago
Solved

Getting Selected Columns for Matrix Visual

Hi,      I am trying to Display year wise budgetary columns in matrix visual, but NOT all columns from every year.   Currently I am getting 6 columns for each year at different categories (rows) l...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi Arshadjehan 

    If so, you could only try these two workaround:

    1. Unpivot the these six columns and then get it as above.

    https://radacad.com/pivot-and-unpivot-with-power-bi

    2. disable the "Word wrap" in Format-> Column headers of matrix, then reduce the column width to 0 manually for year 2016/2017/2018.

     

    Regards,

    Lin

Arshadjehan's avatar
Arshadjehan
Helper I
6 years ago

Hi az38 

Thanks, but how can I hide certain columns for one year and display all columns for other?

az38's avatar
az38
Community Champion
6 years ago

Arshadjehan 

I dont see any chance to do it

do not hesitate to give a kudo to useful posts and mark solutions as solution