Dynamically change table headers according to javascript API parameter

[Anonymous]

Hi all,

I need help to change the table headers or columns according to the parameter I input during embedding the power bi on my application with javascript API. So I have this filter on my frontend application

var  IamAFilter = {
  $schema: "http://powerbi.com/product/schema#basic",
  target: {
    table: "sample_table",
    column: "id"
  },
  operator: "In",
  values: [1]
}

and let's say this is my sample_table or my data

id	column1	column2	column3	column4	column5	column6
1	sample_data	sample_data	sample_data	sample_data	sample_data	sample_data
2	sample_data	sample_data	sample_data	sample_data	sample_data	sample_data
3	sample_data	sample_data	sample_data	sample_data	sample_data	sample_data
4	sample_data	sample_data	sample_data	sample_data	sample_data	sample_data

and

I want to display on my table in power bi if ever my parameter is 1:

table graph in power BI:

column1	column2	column6
sample_data	sample_data	sample_data
sample_data	sample_data	sample_data
sample_data	sample_data	sample_data
sample_data	sample_data	sample_data

I want to display on my table in power bi if ever my parameter is 2:

table graph in power BI:

column2	column5
sample_data	sample_data
sample_data	sample_data
sample_data	sample_data
sample_data	sample_data

these are just examples of the output. Basically I want the columns to change according to the parameter that I passed from my frontend application. Help please I am still new to power BI

[Sergii24]

Hi @Anonymous, I'm not sure that such functionality is present in PoweBI. I'd suggest you to load all columns to your data model (well, actually the minimum number of required columns 😉 ) and then use a feature called "Field Parameter" to dynamically show part of columns.

You can learn more about Field Parameters here - Fields parameters in Power BI

I hope it helps!

[Anonymous]

Thank you @Sergii24  the link you sent is helpful.

I have another question if you don't mind. I think if I can pre-assign the slicer values to ids so that the end-users won't have to select them anymore then that would solve my problem.

• Is there a way to do that?
• Should I create another table for that?

[Sergii24 · Accepted solution]

Hi @Anonymous, as you've seen in the video (min 06:40), you can add extra columns to field parameters table to aggreate values. 

This approach could be useful If you'd assign a column to only one parameter at a time:

Considering that you have "Column2" that should appear for both "Parameter1" and "Parameter2" I'd rather use bookmarks (detail on bookmark)

Good luck and remember to accept an answer as solution if you belive it is useful 🙂