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 v-juanli-msft,
I'm still having trouble....
Doing what you explained me, allows me to have a correct graph... BUT, that makes that the rest of the values from the matrix display the WHOLE purchases of the year. In other words, the filter it's broken on the rest of values.
I attacched you a picture and just in case the PBIX.
Thank you!!