Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Dynamically change table columns according to id

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

 

idcolumn1column2column3column4column5column6
1sample_datasample_datasample_datasample_datasample_datasample_data
2sample_datasample_datasample_datasample_datasample_datasample_data
3sample_datasample_datasample_datasample_datasample_datasample_data
4sample_datasample_datasample_datasample_datasample_datasample_data

 

and

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

table graph in power BI:

column1column2column6
sample_datasample_datasample_data
sample_datasample_datasample_data
sample_datasample_datasample_data
sample_datasample_datasample_data

 

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

table graph in power BI:

column2column5
sample_datasample_data
sample_datasample_data
sample_datasample_data
sample_datasample_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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    just use slicer. you're welcome

    • Anonymous's avatar
      Anonymous
      Not applicable

      I am not sure how the slicer would get the output i need.