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
Hi,
Please share some data to work with and show the expected result. Share data in a format that can be pasted in an MS Excel file.
| 1-10 | 11-30 | 31-45 | 46-60 |
| 500 | 200 | 0 | 100 |
| 300 | 200 | 200 | 0 |
| 100 | 200 | 300 | 400 |
| 200 | 0 | 0 | 100 |
Sure - so in this example, if I drop the 1-10, 11-30, 30-45, and 45-60 columns into slicer fields, what I want is a dropdown/list of 1-10, 11-30, 30-45, and 45-60. Then, if the user selected 1-10, it would update the charts (stacked bar chart) on the tab by removing the other three buckets, leaving the 1,100 total that's in the 1-10 bucket.
Instead, if I drop 1-10 in the field, I'm getting 100, 200, 300, and 500 (the individual cells in the 1-10 column) as my slicer options.
Hope this helps!
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.