Paginated reports: Hide or Show Columns

[Guneet_B21]

Hi Everyone,

I have setup a paginated report with a parameter to hide or unhide columns in the table.

Further i am bringing this report into a pbix file, however i am unable to understand how do i apply the HideValues parameter in PBI Desktop.

Tried using field parameters but in the report parameter selection it's giving me as seperate fields.

[Anonymous]

HI @Guneet_B21,

Perhaps you can take a look at the following link about dynamic hide columns in report server if helps:

sql - reporting services show/hide column base on dynamic query - Stack Overflow

Regards,

Xiaoxin Sheng

[Guneet_B21]

Hi,

i dont think this resolves my issue