Forum Discussion
Controlling Visualizations fields with slicer
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!
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
See my detailed tutorial on this topic, you will be able to choose which columns to display via the slicer.
3 Replies
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
See my detailed tutorial on this topic, you will be able to choose which columns to display via the slicer.
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!
