The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
26 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
33 | |
13 | |
11 | |
9 | |
8 |