Forum Discussion

oliverblane's avatar
oliverblane
Helper III
4 years ago
Solved

Add/Remove Columns of Matrix Visual Using Slicer

I want to be able to add and remove columns from a matrix visual using a slicer, very similar to how it is done in the solution of this question: https://community.powerbi.com/t5/Desktop/Adding-Remov...
Need Help
  • MFelix's avatar
    MFelix
    4 years ago

    Hi oliverblane ,

     

    For this you need to create a disconnected table with the following format:

     

    Now add the following measure:

    Selected Measure value = 
            SWITCH( SELECTEDVALUE(Matrix_Selection[Measure]),
            "Allocated" , SUM(Measure_Selection[Allocated]),
            "Attended", SUM(Measure_Selection[Attended]),
            "Planned Capacity", SUM(Measure_Selection[Planned Capacity])
              )

    Add the Measure column from the previous table on the column below the Month, and the measure above on the values.

     

    Result below and in attach PBIX file.

    Has you can see the matrix on the bottom only show selected measures.

     

oliverblane's avatar
oliverblane
Helper III
4 years ago

Hi MFelix ,

Thanks again for your reply. Visually, this is exactly what I wanted, however when exporting the data, the Allocated/Attended/Planned Capacity columns collapse into a "Measure" column whereas ideally they would remain as separate columns in the exported CSV file just like how they do for the top matrix in the file you shared (I do not mind this happening for the Contract YR and Month columns).

 

Is it possible for those 3 columns to remain separate in the exported CSV?

 

Thank you so much for your help.

MFelix's avatar
MFelix
Super User
4 years ago

Hi oliverblane ,

 

Since this a single measure when you export the values for CSV it will appear in a single column and the measures names will be presented on a different column.

 

Do you need to export to CSV? There is a new option to export the table/matrix in the exact view you have on the service.