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 th...
Need Help
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

lrockwell's avatar
lrockwell
Frequent Visitor
9 years ago

There are upwards of 140 + machines in each location. we are needing to select whichever machine and see the costs for each on a seperate tab as well as by area or groups of machines

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

    Hi lrockwell,

     

    Do you want to show data of each location(site name) on each tab (report page)? Unfortunately, this cannot be achieved automatically. You should create same report on multiple tabs(pages) and add site name into page level filter. Then select different site name for each page.

     

    If what I mentioned above is not your requirement, do you mean you want to show the Site Name/Asset Number which has been selected currrent on report body to tell users which chemical cost to relate to that volume added? If so, you could create a measure like below, and add this measure in a card visual:

    Asset Number selected=Max(Table_name[Asset Number])

     

    Regards,
    Yuliana Gu