Forum Discussion

AryaP's avatar
AryaP
Regular Visitor
5 years ago
Solved

How to Use Table as a Slicer?

Hi everyone,   I am creating a project table in my portfolio dashboard and the table includes: - Project names - Progress plan - Progress actual - Budget - Actual cost   Simply, I want to sh...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    AryaP 

    It sounds like you need to change the type of interaction (Format ribbon; edit interactions) from highlight to filter:

     

    see this example:

     

    Go to Format in the ribbon, select "Edit interactions", select your table visual and change the interaction in the bar chart visual to "Filter"

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi AryaP 

In the values section of your visualization, 

There is a Inverted caret symbol next to it. 

 

Click that and select "Don't Summarize".

  • AryaP's avatar
    AryaP
    Regular Visitor
    5 years ago

    In this case, there is no don't summarize option in the value section of the visualization., just sum, average, median,etc.

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      5 years ago

      AryaP Can you post some screen shots of what you are seeing? Include how the table is configured in the Visualizations pane as well as the bar chart. Or post the PBIX to OneDrive/Box and share a link. Hard to tell what is going on. 

      • AryaP's avatar
        AryaP
        Regular Visitor
        5 years ago

        Hi Greg,

        You can see right, in the dirst two pictures, the sums value of the table still appears.

        I can't find the setting to make them dissapear.

         

         

         


        Well, this is the coloumn chart that I want actually, but Iwant to use it from table instead of slicer.

        This is the chart that I want, but I want to use table instead of slicer