Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Slicing out values from a visual

I'm looking to see if it is possible to set up a line chart and a bar chart to slice out columns as needed from the visuals. My end-user is wanting to see the values of particular cash buckets over time, but those buckets exist as three separate columns within a single table. So for each location and day combination, I have three values I need to portray on a line chart and a bar chart. Showing all three is easy enough, but they want to be able to slice out particular buckets to remove them from the visual.

 

I can't find a way to slice out any of the three columns, bookmarks would get messy with all of the combinations possible, and cross-highlighting doesn't seem to work for this setup.

 

Does anyone have any ideas on how this ask might be implemented or if it is possible?

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    I was able to make something work by unpivoting the table in Power Query based on the given buckets, then using a slicer to remove buckets as usual. It's a bit of a messy fix as I had to create a duplicate of my table, but it worked in the end.

5 Replies

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    5 years ago

    Hey Anonymous ,

     

    why don't you use a slicer and only return a value when a specific bucket is selected.

    When the bucket is not selected you return BLANK(), then the line will not show.

     

    Would that be an option?

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I have a binary field for each bucket to indicate if there ar dollars for that line, but I'm hoping to avoid a Nested If statement for every possibility if at all possible, and can't justify a radical change to the data structure for such a minor request to unpivot the three columns.

       

      Much appreciated though.

      • selimovd's avatar
        selimovd
        Icon for Most Valuable Professional rankMost Valuable Professional
        5 years ago

        Anonymous Can you maybe show how your data is structured, your data model and what exactly you want to archive. I'm not sure if I fully understood your requirements.

         

        Thank you and best regards

        Denis

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I was able to make something work by unpivoting the table in Power Query based on the given buckets, then using a slicer to remove buckets as usual. It's a bit of a messy fix as I had to create a duplicate of my table, but it worked in the end.