Controlling Visualizations fields with slicer

[AutoJL]

Hi!

I am stuck with something that either is very easy ( and im just overthinking it ) or is flat out imposible ( and I just though that could be done because it is similar to other requests)

I have a table that compiles both the customer names of my customers as well as the specific system Serial number they have installed. 

Now I have created a report with a couple of pages that comes from 2 main data sources, one has the info linked to the serial number and the other to the customer name. With this table I mentioned before I can totally navigate all the visualizations with no issues and everything works just fine.... But I though "What if I bring it to the next level?" And my idea was to have a slicer where you can chose either "Serial number" or "Customer name" and then the visualizations would use said selection (I know one workaround for this is simply using the option that is not in the visualization currently in the "tooltip" field so it gets displayed when people hover above whatever visual it is but I think the other option is cleaner).

I believe there has to be something like the selectedvalue-switch that can be used with measures but since I am not using measures ( its just the 2 raw columns of my table) I keep coming up with DAX errors when trying to implement this method.

 What I get is "A single value for column 'Customer Name' in table 'Customer Names - SN' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."

Any tips or ideas on how to do this? (Or first of, Can it be done?)

Many thanks!

[jdbuchanan71 · Accepted solution]

@AutoJL 

What you are describing sounds like Filed Parameters.  You want to set it up so you can display either the Customer or the Serial Number on the rows of a table for example.

In my example I have one called "Category Selection"

I can show any mix of the following columns using a slicer

"Interface Name"
"Client Name"
"Vendor Name"
"Step Desc"
"FileKey Status"
"Error Type"

When I change the selection in the slicer the displayed column changes.

Here is a video on the functionality.

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

[AutoJL]

Glad to see its just my bad memory 😂. This sw has so many features that I keep struggling to remember everything. So lucky there is always this amazing community to help out!.

Many thanks to both @jdbuchanan71  and @miTutorials  for the super fast and accurate answers!

[miTutorials · Accepted solution]

See my detailed tutorial on this topic, you will be able to choose which columns to display via the slicer.

New Feature: Slicer to choose which columns to display on chart using Fields Parameter in PowerBI - ...

[jdbuchanan71 · Accepted solution]

@AutoJL 

What you are describing sounds like Filed Parameters.  You want to set it up so you can display either the Customer or the Serial Number on the rows of a table for example.

In my example I have one called "Category Selection"

I can show any mix of the following columns using a slicer

"Interface Name"
"Client Name"
"Vendor Name"
"Step Desc"
"FileKey Status"
"Error Type"

When I change the selection in the slicer the displayed column changes.

Here is a video on the functionality.

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters