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.
In Power Bi desktop tabel visual, my data is displaying as shown in table 1 below however I would like to display as in table2, please assist or any guidance on how I can will be helpful.
Solved! Go to Solution.
Hi @Libin7963
There are default options in Matrix chart to implement like this.
This above table is your input table
This is your output table. For this you have to drag all your columns in Rows section(pls see below)
Then your matrix chart will show like this
Then you click drill down to lowerlevel, you will get the result as you expected.
Thanks for bringing up this question.
Hi @Libin7963
There are default options in Matrix chart to implement like this.
This above table is your input table
This is your output table. For this you have to drag all your columns in Rows section(pls see below)
Then your matrix chart will show like this
Then you click drill down to lowerlevel, you will get the result as you expected.
Thanks for bringing up this question.
Hi vicky_ ,thanks for the quick reply, I'll add more.
Hi @Libin7963 ,
There may not be a direct way to achieve your needs. I think you can use DAX to indirectly achieve your needs, as long as the amount of data here is not too much. If the amount of data is too much, it will be displayed abnormally in the visual.
You can use the 'CONCATENATEX' function.
CONCATENATEX function (DAX) - DAX | Microsoft Learn
Colour_code = CONCATENATEX('Table',[Colour code],UNICHAR(10))
Colour_ = CONCATENATEX('Table',[Colour],UNICHAR(10))
Best Regards,
Wenbin Zhou
I don't think you can get 100% of the way there with the default visuals, but you can get pretty close by using a Matrix visual, and then changing the Style to Outline: https://www.linkedin.com/pulse/new-power-bi-matrix-layouts-pbicorevisuals-cr1if and then keep expanding all the way down to the Colour level of your heirarchy.
User | Count |
---|---|
78 | |
74 | |
42 | |
32 | |
28 |
User | Count |
---|---|
104 | |
93 | |
52 | |
50 | |
46 |