Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 7 | |
| 6 | |
| 4 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 17 | |
| 8 | |
| 8 | |
| 7 |