The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Pls help me, in figure out how to place Description and Stockcode in same level of hireracy in Matrix
I wan to see the total of Brand level as well , Is there any way I can combine both Columns( description and Stockcode) into Single Column . Then I can show both of them simultaneously.
Hi @Anonymous ,
The closest you can get to that is by disabling the Stepped Layout.
Is there any way I can combine both Columns( description and Stockcode) into Single Column . I think It might Work right?
You can concatenate them using ampersand "&" just like you would in Excel, CONCATENATE (accepts two columns only) or COMBINEVALUES (accepts a delimiter and more than two columns).
This isn't exactly supported in the regular PowerBI matrix.
Two easiest ways i can think of:
first is to create a calculated column that combines Description and Stock Code, and any other columns you want on the same heirarchy level (maybe using CONCATENATE() function?)
Or you can turn off stepped layout in the formatting options