user selectd columns in report

[Anonymous]

Hi,

I have this request: user wants a report where he can choose to add some columns to it.

This is the scenario: I have a calculated table with 5 columns (ie. product, category, state, city, salesperson) and the numeric count of product. (CoP)

Now, the basic report always shows Product and CoP. The user wants to have the option to select what columns to show in a table or matrix, like this:

Product  (Category and/or State and/or City and/or salesperson)  CoP

The only restriction is that Product has to be the first column and CoP the last.

I have been able to dynamically change calculated measures in a report, but this is a new one for me.

Thank you in advance for your kind response.

[v-shex-msft]

Hi @Anonymous,

According to your description, you want to dynamic setting the visible of chart fields, right?

If this is a case, currently power bi charts not support this feature, you can vote the idea below:

Dynamic Visibility

Regards,

Xiaoxin Sheng