One parameter ,two slicers

[pstanek]

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

[OwenAuger]

@pstanek

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