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.

     

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.

 

 

oliverblane's avatar
oliverblane
Helper III
4 years ago

I am glad you pointed that out - I did not realise there was that option in the service. Thank you very much for your help!