Forum Discussion
Line Chart until selected month
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)
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)
Hi okusai3000
I tested before, but i 'm afraid i am unable to solve this problem.
Maybe you could use diferent measures in these visuals, this is to say, in the line chart, put the measures i suggested in the previous post, and put your measures in the other visuals.
Best Regards
Maggie
Hi Maggie,
Would like to tell you that finally I managed to solved it. The key thing was to copy the whole database table; then create the same measures again (with the reference to this new table); and now use this table to create the graph, of course using the Measure 2 and measure 3 that you showed me.
In this way, as this table will be isolated from the rest (with no relations), there won't be any confusion on filters and everything will just work flawlessly!
Thank you so much!