Forum Discussion

lrockwell's avatar
lrockwell
Frequent Visitor
9 years ago

Report Filter

I am trying to filter all of a report by a Site Name. then within the report i will utilize Asset Numbers for that site to chart various things. I create a filter under the Report filter and check the Site Name I want to filter. Then add the chart and then add the Asset Number as a slicer to be able to choose which of the 75+ machines for a given site i want to show data for, but it is not limiting the asset numbers it to that site only.. it is still grabbing Asset Numbers from all 12 Sites. What am i doing wrong. 

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Without knowing anything about how your data is structured, it's hard to say.

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    9 years ago

    Hi lrockwell,

     

    Please elaborate your scenario with some detailed data and examples. According to current description, it's not very clear about  what your report looks like and what you want to achieve.

     

    Best regards,
    Yuliana Gu

    • lrockwell's avatar
      lrockwell
      Frequent Visitor
      9 years ago

       

      I have a report that I am trying to take the volume added of a chemical (by asset number) and calculate the costs of the chemical by the volume added. I have been unable to make the connection between the two. Often times there are more than one chemical used on a single asset so somehow i have to tell it which chemical cost to relate to that volume added. Any help is appreciated. 

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Microsoft Employee
        9 years ago

        Hi lrockwell,

         

        You want to distinguish chemical cost between multiple types of chemical because of the multi-selected values from a slicer, right?

         

        What if adding the asset number into legend section of the chart visual?

         

        Regards,
        Yuliana Gu