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 everyone, I want to create a matrix table that looks something like the table below. In the table, I will show the target value for each tier, and I have an Actual column to check which tier does it belong to and Position column will state the current tier.
E.g., Current actual value is 2,500 and it's greater than Tier 2 and lower than Tier 3, hence it will be parked under Tier 2.
My problem here is how can I check which tier do I belong to and display the actual value and tier number in the same row?
This is how my Dim_Tier looks like and it has no relationship with Fact_Actual
Regards,
BK
Solved! Go to Solution.
Hi, @Anonymous
Please check the below pictures and the sample pbix file's link down below, whether it is what you are looking for.
All measures are in the sample pbix file.
In my opinion, I think you need to create a Dim Tier Table like below.
https://www.dropbox.com/s/iwnv2ax7g28mvag/beekee.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @Anonymous
Please check the below pictures and the sample pbix file's link down below, whether it is what you are looking for.
All measures are in the sample pbix file.
In my opinion, I think you need to create a Dim Tier Table like below.
https://www.dropbox.com/s/iwnv2ax7g28mvag/beekee.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 |
---|---|
98 | |
96 | |
75 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |