Forum Discussion

okusai3000's avatar
okusai3000
Helper IV
7 years ago
Solved

Line Chart until selected month

Hello everyone,     I have made a supplyers report where I'm showing how high has been the total purchase until the month selected.  On my first version, I did the running total more "manually" in...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi okusai3000

     

     

    finally, add the month column from the new created table to a slcier, select an item in this slicer, the line chart only show values untill the selected month. 

    You only need one slicer, the column added to the slicer is the month column from your new created table, not your original table.

     

    Measure 2 = SELECTEDVALUE(Table1[month])

    This show the item when you select a item in the slicer, Table1 is the new created table.

     

    Measure 3 = IF(MAX(your original table[month])<=[Measure 2],1,0)

     

     

okusai3000's avatar
okusai3000
Helper IV
7 years ago

Hi Maggie,

 

I cannot understand the thing about the filter. I mean, from what I understand you, in that way I would end up having 2 filters?

 

Thanks!

 

 

EDIT: I get something like this:

 

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi okusai3000

 

 

finally, add the month column from the new created table to a slcier, select an item in this slicer, the line chart only show values untill the selected month. 

You only need one slicer, the column added to the slicer is the month column from your new created table, not your original table.

 

Measure 2 = SELECTEDVALUE(Table1[month])

This show the item when you select a item in the slicer, Table1 is the new created table.

 

Measure 3 = IF(MAX(your original table[month])<=[Measure 2],1,0)