Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am trying to build a report… I have a fact with Revenue and dimensions: Date, Client, ClientType.
ClientType table:
CustomerNo | FY | Type |
1 | 2018 | xyz |
1 | 2019 | xyzz |
1 | 2020 | xyzz |
1 | 2021 | xyzz2 |
2 | 2018 | xyz |
2 | 2019 | xyz |
2 | 2020 | xyz |
2 | 2021 | xyz2 |
For each Year, each customer has a Type.
In the report, a single-selection filter on FY will be included.
My goal is, if FY 2021 is selected:
Likewise if FY 2020 is displayed, the LY measures, shall display under the type of FY 2020.
Can the above be achieved? Can/shall I connect Date table with ClientType (even though they have different granularity?)
Can you please post a depiction of the expected result?
Proud to be a Super User!
Paul on Linkedin.
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
9 | |
6 |