Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
I have a Date Table with Year filter and Comparison column from Compare table and i need to show the below structure based on the Year selected.
Comparison | Actual | Target1 | Target2 | Plan | Plan | ||
Name | 2019 | 2018 | 2017 | 2018 | 2018 | 2018 | 2019 |
A | |||||||
B | |||||||
C |
For Example : If i select year 2018 , then "Actual" from my Comparison should show all the data available irrespective of the year selected. Then my "Target1","Target2" and "Plan" should show the data for the selected year. And "Plan" should also show the data for next year w.r.t the selected year.
Please let me know how to achieve the above solution in one single matrix.
Regards
SHIVA KUMAR
Hi @ncbshiva
This may not be achieved by one single matrix, maybe we could try several matrixs/tables and match them to show expected visual.
Best Regards
Maggie
Currently i am using several matrices and combined them to show as single matrix. But this will not work because i have more than 10,000 records , so users need to scroll down , which is not possible to work with three different matrices
Please let me know if this can be achieved by DAX .
Regards
SHIVA KUMAR
Can anyone please help me to achieve this solution ?
Regards
SHIVA KUMAR
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |