Forum Discussion

melelane's avatar
melelane
New Member
4 years ago
Solved

assistance with a visual

Hi I'm still looking for some assistance with a visual. Attached is the graph that I'd like to fix. As you can see I'm using the exact same source/data for both the line and the columns. I'd like to filter the line so that it shows an acceptance rate of submissions while the columns show the overall submissions. I know I can do this if I'm able to apply a filter from another set of data that I have that has the categories that need to be filtered out. All of the data is linked together as it's all from the same excel spreadsheet. I just want the filter that I apply to only effect the line value. 

below is a graph and filter.

Need Help
  • RayWu's avatar
    RayWu
    4 years ago

    melelane You need create two measures which filter for both criteria.

     

    LineMeasure = CALCULATE ( SUM ( Quantity ) , FilterItem = "A" )

     

     ColumnMeasure = CALUCLATE ( SUM ( Quantity ), FilterItem = "B" )

     

    Both of the measures will display different values and are filtered for different criteria
    No need to apply a filter at the visual level. I hope this will help

2 Replies

  • RayWu's avatar
    RayWu
    Icon for Memorable Member rankMemorable Member
    4 years ago

    melelane You need create two measures which filter for both criteria.

     

    LineMeasure = CALCULATE ( SUM ( Quantity ) , FilterItem = "A" )

     

     ColumnMeasure = CALUCLATE ( SUM ( Quantity ), FilterItem = "B" )

     

    Both of the measures will display different values and are filtered for different criteria
    No need to apply a filter at the visual level. I hope this will help