Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
pstanek
Post Patron
Post Patron

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 1
OwenAuger
Super User
Super User

@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


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.