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 all, I was trying to change the sequence of the columns shown in matrix table.
As per screenshot below, it is currently shown as countries (normal fixed columns - ID, MY etc.), then the values of field parameters based on drop down (eg. NTS PY, NTS LT...)
However, in the columns, I would prefer to show the field parameter values first, then the markets (eg. NTS PY, then ID MY PH..; then NTS LT, then ID MY PH..). Hope to achieve the visual preference so that I can see each field parameter category at one glance. Thanks!
Hi @dsl98
Try to put your filed parameter category in column then your country in column of matrix visual.
I hope by this way you get the desired result.
Thank you for your reply. I tried but it did not work. If I remove the Values and keep the 2 columns, it will be blank.
I also drilled up and down using different order of sequence, but it did not work too.