The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I need to create the below table in power bi.
I can create the measures without any issues.
But the issue I am having is presenting my data in the table format exactly like below.
Like, how does one go about creating custom row labels like "Annual Target", "YTD", Revenue to achieve target", "Trading Days", "Required Run Rate" and making the right measures appear next to them?
I really need to know how to do this as this is just one example of this particular scenario.
Thanks,
Solved! Go to Solution.
You put the measures you created in the value section of the matrix visual. If you need to change the name of the measure for the visual, you can do it in the pill in the values section:
Please mark this post as a solution if i t helps you. Appreciate Kudos.
Since it's the header the easiest way would be to just layer a text box or card visual over it and put in whatever you want
Sorry, I forgot to ask one more thing, how can I add header/some text in the section I boxed in red in the visual below?
Since it's the header the easiest way would be to just layer a text box or card visual over it and put in whatever you want
That doesn't help at all.
Where do I input custom row names, how do I assign the right measures to my row names so that when I display it, the right row has the right measure next to it.
You put the measures you created in the value section of the matrix visual. If you need to change the name of the measure for the visual, you can do it in the pill in the values section:
Please mark this post as a solution if i t helps you. Appreciate Kudos.
Use a Matrix visual and then in formatting go to Values > Options > Switch values to rows and toggle on
Please mark this post as a solution if it helps you. Appreciate Kudos.
User | Count |
---|---|
77 | |
76 | |
36 | |
31 | |
29 |
User | Count |
---|---|
93 | |
79 | |
57 | |
48 | |
48 |