Forum Discussion
One parameter ,two slicers
Hi I have table with columns date( Datetime or date or months) , price(number) , company(string).
I would like to create visual with 4 columns Company name, Total price period 1, Total price period 2 , Total price period 2 / Total price period 1
I want to determine period 1 , period 2 by slicers that depend on column date at the same time.
Do you have any idea? Visual level slicers are useless because period 1 is not period 2. Measure , I am not sure that it will be dynamic . I mean user who will use visual , he will determine period, not by creating measure with fixed periodes.
Fo example - Q1 2017 vs q1 2018 , January 2018 vs February 2018. Q2 2018 vs Q3 2018 etc
1 Reply
You can use the method presented in this article:
https://www.sqlbi.com/articles/filtering-and-comparing-different-time-periods-with-power-bi/
It relies on having a Date table and a 'Previous Date' table (with an inactive relationship).
Have a look at that and please post back if you need further assistance applying it in your model.
Regards,
Owen
