Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there,
I have a dataset with Open End answers that have been codified the codes translate into fields in power BI, but I would like to have a drop-down list in the dashboard with all the codes to be able to select and filter per code.
Is that possible?
Thanks,
Sara
Solved! Go to Solution.
hi, @Anonymous
After my research, I'm afraid it couldn't achieve that have a slicer with three columns as you want on your original data structure in Power BI for now. You may try to use three slicers like this:
Also, if you want them in one slicer, you may try to use this way:
In Edit Queries, select accessibility, booking, experience then click Transform-> Unpivot columns
then drag field Attribute and Values into slicer like this
By the way, This method will turn your this data table three times as large.
and here is demo pbix, please try it.
Best Regards,
Lin
Hope this find you helpfull
Yes, this seems to be very mych possible.
Please share a sample of your data.
See my updated post 😉
I am not sure how simple it would seem but you can just add a slicer visual and add the code field to it
A slicer visual is only showing the option of data for each of the fields (positive / negative / neutral). However, what I need is a slicer visual that has the codes: accessibility, booking, experience.
Do you have any ideas on how that could work? Would the option of transposing the table work?
hi, @Anonymous
You may try to a custom visual "HierarchySlicer" in MarketPlace.
Then darg field by parent-child structure like below:
Best Regards,
Lin
hi, @Anonymous
The slicer only shows the values of the fields, whereas I need the header.
Do want to just select the header that like select "year" then show all year, but in power bi, when you don't select any value in slicer, it will like select all, show all values. It doesn't make sense.
If I get it wrong, Can you explain to me according to the sample data and expected output?
Best Regards,
Lin
Hi Lin,
If you look at the fields these are:
- accessibility
- booking
- experience
I want to show these in the dashboard, so people can select whether to see comment for each of the topics. So, I'd like to have a slicer with the following:
- accessibility
- Positive
- Negative
- booking
- Positive
- Negative
- experience
- Positive
- Negative
Does that make sense?
hi, @Anonymous
After my research, I'm afraid it couldn't achieve that have a slicer with three columns as you want on your original data structure in Power BI for now. You may try to use three slicers like this:
Also, if you want them in one slicer, you may try to use this way:
In Edit Queries, select accessibility, booking, experience then click Transform-> Unpivot columns
then drag field Attribute and Values into slicer like this
By the way, This method will turn your this data table three times as large.
and here is demo pbix, please try it.
Best Regards,
Lin
hi, @Anonymous
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Best Regards,
Lin
Hi there,
It is definitely a good way around it, although I don't think it's gonna work for me as I have 20 different attributes with multiple entries for each, so I feel the data set gets simply too long.
But I'll marke the solution as such
Thanks,
Sara
Hi Affan,
If you look at the fields these are:
- accessibility
- booking
- experience
I want to show these in the dashboard, so people can select whether to see comment for each of the topics. So, I'd like to have a slicer with the following:
- accessibility
- Positive
- Negative
- booking
- Positive
- Negative
- experience
- Positive
- Negative
Does that make sense?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |