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
Assume your running total is correct, to get all the values until the selected month,
first create a new table with a month column (note that don't create relationship between this new table and your data table)
then create a measure
Measure 2 = SELECTEDVALUE(Table1[month])
next create another measure, and add this measure to the visual level filer of the line chart, set 'show items when value is 1)
Measure 3 = IF(MAX([month])<=[Measure 2],1,0)
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.
This is limited for the axis doesn't show other months except the months before selected month.
Best Regards
Maggie
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:
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!!
- Maggie, Can you please check the last message that I wrote on this post please? :)
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