Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Solved! Go to Solution.
Hi @keduave, 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 🙂
Hi @keduave, 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!
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.
Hi @keduave, 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 🙂
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.