Dynamically changing column attributes in the table

[Anonymous]

Hi,

I have a table visualization with attributes A,B,C,D and E let's say.

I have a date filter which is a report level filter. For months prior to June 2019 (including June 2019), attribute E did not exist or was not calculated. So, if a user selects any date which is June 2019 or prior in the report level filter, the table should not show attribute E. Instead, it should show another attribute F as a substitute for attribute E. 

Scenario 1: User selects any period after June 2019 i.e. July 2019 onwards....Table should show attributes A,B,C,D and E.

Scenario 2: User selects any period prior to June 2019 or June 2019.....Table should show attributes A,B,C,D and F.

Can the columns or attributes in a table be dynamically displayed based on report level filter selection?

Thanks,

Vishy

[amitchandak]

See if powerbi bookmarks can help you

https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks

[Anonymous]

Thanks @amitchandak , not sure how bookmarks would help. Can you elaborate?

[Mann]

Hi,

We cant trigger a bookmark from report level filters in Power BI as of now. Also if you using bookmarks in your report then best would be to create a bookmark for this table and card with "Selected value" option. This would minimise the impact of this added card in other book marks.

Mann

[Mann · Accepted solution]

Hi,

You can create a calculated column with this logic:
If(Date>"June 2019", [Column E], [Column F])

This new column can be used as 5th column in your table visual.

Since we cant dynamically change the column header in Power BI table visual as of now so work around can be to place a card visual on this column header and add a measure there with similar logic like above. Keep the formatting same.

Mann.

[Anonymous]

Thanks @Mann for the suggestion. Yes the measure value isn't a problem and can be handled by IF condition. Issue is with the column headers and as you mentioned in your workaround, it can be tried. But there are multiple versions of the reports along with various bookmarks etc. so having a card visual could cause some formatting issues.

[Ashish_Mathur]

Hi,

If by attributes you mean measures, then i do not think this is possible.

[Anonymous]

Yes @Ashish_Mathur , I meant measures. Thanks for the info.