Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello Power BI community,
I'm facing an issue with adding a new field parameter to my existing list in Power BI Country.pbix . Currently, I have a fields parameter that I use in visuals and visual filters to filter data based on the file I choose. First here's my table :
Here is a snippet of my existing parameter:
and it's used like this in visuals with diff metrics
Now, I want to add a new parameter based on the category column from the table, meaning that when I choose Country from the filter the table gives me names with category "Country". I tried the following by specifying the category name but it didn't work when I select it from the filter it doesn't exclude the other that aren't countries:
Could someone please help me to achieve this? Any suggestions or guidance would be greatly appreciated.
Thank you in advance!
Solved! Go to Solution.
Hi, I think what you can do is create a calculated column that will have Country categories only.
In MS official documentation, it reads as follows,
Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn
... if you want to add a new field to an existing parameter, ... and match the format shown in this example.
Parameter = {
("Customer", NAMEOF('Customer'[Customer]), 0),
("Category", NAMEOF('Product'[Category]), 1),
("Color", NAMEOF('Product'[Color]), 2),
("Product", NAMEOF('Product'[Product]), 3)
}
So, your expression might not be recognizable in a field parameter table.
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LearnAndPractise(Everyday) ) |
In MS official documentation, it reads as follows,
Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn
... if you want to add a new field to an existing parameter, ... and match the format shown in this example.
Parameter = {
("Customer", NAMEOF('Customer'[Customer]), 0),
("Category", NAMEOF('Product'[Category]), 1),
("Color", NAMEOF('Product'[Color]), 2),
("Product", NAMEOF('Product'[Product]), 3)
}
So, your expression might not be recognizable in a field parameter table.
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LearnAndPractise(Everyday) ) |
Hi, I think what you can do is create a calculated column that will have Country categories only.