Filter Columns in Table Based on Filter

[sk15227]

Hi,

Is there a way to filter columns in a table? for example, in the table below, if no Month is selected, I want to show the fields ENTRIES test, % Entries Full Year, and Count Weekday Full Year.

If I click on a certain month, I only want the ENTRIES test, % Entries, and Count Weekday fields to be shown.

Is this possible?

Thank you!
Sarah

[v-lili6-msft · Accepted solution]

hi  @sk15227 

For your case, you could try this way to get it:

Step1:

Add a new table that contains these five measures name

Step2:

Then create a measure as below

Measure =
SWITCH(SELECTEDVALUE('Columns'[Type]),
"ENTRIES test",[ENTRIES test],
"% Entries Full Year",IF(ISFILTERED('Table'[Month]),BLANK(),[% Entries Full Year]),
"Count Weekday Full Year",IF(ISFILTERED('Table'[Month]),BLANK(),[Count Weekday Full Year]),
"% Entries",IF(ISFILTERED('Table'[Month]),[% Entries],BLANK()),
"Count Weekday",IF(ISFILTERED('Table'[Month]),[Count Weekday],BLANK()))

Step3:

Now drag Type field into columns of matrix visual and this measure instead of these five measure into visual.

here is simple sample pbix file.

Result:

Regards,

Lin

[az38]

Hi @sk15227 

no, sorry

only play with bookmarks