Forum Discussion
Get data for previous 8(Current + Previous 7 quarters) data based on slicer selection
Hi, I want to show the line chart which shows the last 8 quarters of data ( selected quarter + previous 7 quarters data) based on slicer selection. I have a simple data table without date fie...
1) We need to create a column (Index)
2) also need to create two unrelated tables
3) need to correctly insert slicer and matrix columns
4) create measure
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26Rhj6wb7rJPiGmynJB?e=vWbuxT
Hi I have used it for showing a measure values in a matrix visual where some quarters data is is missing ,is this work for measures also.
Thanks in Advance