Forum Discussion

Frequent Visitor

7 months ago

Solved

Field parameter slicer to add extra columns in table visual

I know there is a way to do this with field parameter, but after searching online and trying out myself with Power BI, I couldn't seem to find a solution that works how I wanted.. So, I have a ...

Need Help

Show and Tell

danextian
7 months ago
If the goal is to show or hide two specific columns using a slicer, there’s no need to add everything to the parameter table. Add the columns or measures for those two columns first, then add the parameter, followed by the remaining columns or measures. Any columns or measures not coming from the parameter table will not be affected by the slicer selection.

Millabu

Frequent Visitor

7 months ago

Thank you all dk_dk , lbendlin and danextian for your replies so far!

So what I am trying to re-create is this that I know has been done before:

Here is the Field Parameter that was created:

Parameter = {

("Account name", NAMEOF('Account_combined (2)'[name]), 0),

("Business ID", NAMEOF('Account_combined (2)'[VAT]), 1),

("Customer Lifecycle Status", NAMEOF('Account_combined (2)'[Lifecycle and category.Customer Lifecycle Status]), 2),

("Customer Category", NAMEOF('Account_combined (2)'[Lifecycle and category.Customer Categorization]), 3),

("Data in Source 1", NAMEOF('Account_combined'[Data in Source 1]), 4),

("Data in Source 2", NAMEOF('Account_combined'[Data in Source 2]), 5),

("CCM Leads", NAMEOF('Lead_combined'[CCM Leads (Filtered)]), 6),

("H&C Leads", NAMEOF('Lead_combined'[H&C Leads (Filtered)]), 7),

("Hydrogen Leads", NAMEOF('Lead_combined'[Hydrogen Leads (Filtered)]), 8),

("Nuclear Services Leads", NAMEOF('Lead_combined'[Nuclear Services Leads (Filtered)]), 9),

("CCM Opportunities", NAMEOF('Opportunity_combined'[CCM Opportunities (Filtered)]), 10),

("H&C Opportunities", NAMEOF('Opportunity_combined'[H&C Opportunities (Filtered)]), 11),

("Hydrogen Opportunities", NAMEOF('Opportunity_combined'[Hydrogen Opportunities (Filtered)]), 12),

("Nuclear Services Opportunities", NAMEOF('Opportunity_combined'[Nuclear Services Opportunities (Filtered)]), 13),

("Sales Activity in Number of Units", NAMEOF('Account_combined'[Sales Activity in Number of Units]), 14)

}

And there is a slicer visual and a table visual in the report, where looking at the Build section the slicer uses the Parameter 3 as value and table uses the same Parameter 3 in columns.

I see from the Slicer's visual Filters that it has only Customer Lifecycle Status and Customer Category ticked:

And when there are no selections on the slicer, the table's visual Filters looks like this (both Customer Lifecycle Status and Customer Category are ticked but have "0" next to them):

And when one or both of the slicer values are selected, they show similarly as the rest of the columns:

For some reason I have not been able to re-create this one, but it seems to be possible. So I don't know if I'm just missing some detail...

dk_dk
Super User
7 months ago
Hi Millabu
You threw me a curve ball with this but (I think) i managed to replicate this behavior. Kind of. I can't get it to work with the classic slicer, but I can with the new one (but it looks different):

I added the parameter to the new slicer (you can format it to a vertical list but it wont have the selection boxes, rather its a bunch of cards. I selected by hand ALL of the parameters. The order in which they were selected decides the column order. I duplicated the slicer. Only on the second slicer I added a visual level filter to filter it to the category and lifecycle columns. Then I simply hid the first slicer (View>Selection>Hide visual) and this is what I was left with:

It has the behavior you want but I cannot format it the same way.

Could you check:
- if this works for you for your recreation
- which type of slicer visual is used in the original project you took the screenshots of
- if there is a hidden slicer on the report page in the original project as well
- Millabu
  Frequent Visitor
  7 months ago
  Hello, and thank you so much for puttig effort on solving this! You asked:
  
  - which type of slicer visual is used in the original project you took the screenshots of --> List slicer (new slicer)
  - if there is a hidden slicer on the report page in the original project as well --> there are no hidden slicers
  
  I tried to replicate what you did, and maybe I'm just not seeing something or then there is another reason my table visual is not behaving same way as yours:
  
  1. I added a slicer (List slicer) and a table visual on a report page. I put the Parameter in the table visual values, and after that I selected ALL the values in the slicer.
  2. I duplicated the slicer and I added a visual level filter to filter it to the category and lifecycle columns. And then I hid the first sicer.
  3. Left with this, I havea table with all the columns, and when I choose a value or boht values on the slicer, the table only filters to those ones and does not show the rest of the columns. Below are the screenshots to demonstrate this.
  
  I don't understand what I'm missing here 😅
danextian
Super User
7 months ago
If the goal is to show or hide two specific columns using a slicer, there’s no need to add everything to the parameter table. Add the columns or measures for those two columns first, then add the parameter, followed by the remaining columns or measures. Any columns or measures not coming from the parameter table will not be affected by the slicer selection.