Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi All,
I have a power bi report with matrix visual.
I have used nearly 3 dimesniosns in ROWS and 10 metrics in values. In matrix, how i can display the top 3 heading
(FULL YEAR / YTD / Month)
Thanks,
Maya
Solved! Go to Solution.
Hi @Maya2988,
I have updated the output as per your requirements. Please check the attached .pbix file.
I hope this helps! If it does, please consider "Accept as solution" and giving it a 'Kudos' to make it easier for others to find.
Thank you.
Hi @Maya2988,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
Hi @Maya2988,
May I ask if you have resolved this issue? If so, please mark it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi @Maya2988,
Thank you for reaching out to the Microsoft Fabric Forum Community.
I have reproduced scenario with my sample data. The issue with the group headings not being stable during horizontal scrolling has been resolved. By using a 'Category' table and measures, I have successfully fixed the problem. When you scroll your matrix horizontally now, the 'FULL YEAR', 'YTD', and 'Month' headings should remain fixed in their positions.
I'm also attaching a .pbix file to this response for your reference. You can open it in Power BI Desktop to see the solution implemented directly.
Note: To implement this, you'll need to create a 'Category' table with a single column named 'Category' and add the values 'FULL YEAR', 'YTD', and 'Month' as rows.
If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
Hi
I could see the metrics are repeating for all the 3 category.
FULL YTD - Month 25 Act , Month 24 Act, YTD25 Act, YTD 24 Act, FY25 Act, FY24 Act ect.,
Month - Month 25 Act , Month 24 Act, YTD25 Act, YTD 24 Act, FY25 Act, FY24 Act
Thanks,
Maya
Hi @Maya2988,
You're absolutely right, my primary focus was on resolving the scrolling issue you initially reported. However, I see you're now experiencing repeating metrics across all categories, which is not the intended behavior.
After reviewing the DAX measures, I've confirmed that they are correct. Therefore, the issue is likely due to a relationship problem between the 'Category' table and your data table, or unintended filters on the matrix visual or the report page.
Please check the following:
If this helps, kindly consider marking this response as "Accept as Solution" and giving it a "Kudos" to assist other community members facing similar challenges.
Thanks.
Hi
Could you please help me to create link between category and fact table
Thanks,
Maya
Hi @Maya2988,
You're correct, there is no direct relationship between the 'Category' table and your fact table (SalesData). In this case, we don't need to create a physical link between them.
Instead, the relationship is established virtually through the DAX measures we created. The SELECTEDVALUE(Category[Category]) function within each measure acts as a filter. It ensures that each measure only displays values when the 'Category' column in the matrix matches the category specified in the measure.
If you find this information useful, please accept it as a solution and give it a 'Kudos' to assist others in locating it easily.
Thank you.
Yes. Here no physical link created. So metrics are repeated.
Basically i need data as like below
Hi @Maya2988,
I have updated the output as per your requirements. Please check the attached .pbix file.
I hope this helps! If it does, please consider "Accept as solution" and giving it a 'Kudos' to make it easier for others to find.
Thank you.
Hi @Maya2988,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.
Thank you.
Hi @Maya2988 ,
Please try using the below:-
Create a Field Parameter:
Go to Modeling → New Parameter → Fields.
Add your 10 metrics and categorize them into groups:
FULL YEAR: FY25 ACT, FY24 ACT, FY25 BUD, FY24 BUD, VAR.
YTD: YTD25 ACT, YTD24 ACT, VAR.
Month: Month 25 Act, Month 24 Act, Month 25 Bud, Month 24 Bud.
Use the Field Parameter in Columns:
Drag the newly created Field Parameter into the Columns field.
This will group metrics under FULL YEAR, YTD, and Month.
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
This is a good solutions but group heading is not stable like if i will scroll left to right the matrix table, then FULL YEAR heading go to YTD metrics
User | Count |
---|---|
85 | |
79 | |
64 | |
52 | |
46 |
User | Count |
---|---|
101 | |
49 | |
42 | |
39 | |
38 |