Forum Discussion
Help with slicer
Hi,
If that is the raw data, then you need to use the "Unpivot" feature to reshape the data in which all buckets appear in a single column.
Hello rhett_h1983,
I reproduced your scenario by creating a slicer-only helper table (using Reference + Unpivot) to expose the bucket names, linked it back to the original data and confirmed that the slicer correctly filters the totals without impacting existing visuals.
For your reference, I’ve attached a .pbix file demonstrating this working end-to-end and thanks, danextian & Ashish_Mathur for sharing valuable insights.Best regards,
Ganesh Singamshetty
Are those numbers under the bucket from a measure or column?
They're from fixed decimal number columns, so there are many more rows of similar data in the various buckets.
Transform your data in the query editor. If there are columns that need to be kept as-is, select those columns, right-click then click Unpivot Other Columns otherwise select all columns then Unpivot Columns.
Thanks for the suggestion, but I use the same columns for other graphs, and unpivoting those columns impacts the other graphs. I also tried duplicating those rows and unpivoting the duplicates, but it also impacts the graphs on the tab. I can put the 'Attribute' column into a slider and it looks like I want it to look, but I also noticed that while clicking on the various options, the data doesn't change.
I have also tried creating a new parameter, but when I replace the buckets in the axis or values fields with the new parameter, it stays blank when I click the different buckets.