Forum Discussion
Filter Columns in Table Based on Filter
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
hi Anonymous
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
2 Replies
hi Anonymous
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
Hi Anonymous
no, sorry
only play with bookmarks
