topic Re: How to create a table with columns & rows which is not pivot in DAX Commands and Tips

How to create a table with columns & rows which is not pivot

Anonymous — Sun, 04 Aug 2024 11:33:30 GMT

Hi All,

I have 1 excel file that contain columns and connected to "dates" excel,

in the excel file I have many columns, I want to create a table like the pic below :

when the rows are columns from the wxcel and the columns are coming from dates

the problem is that under regular table visual I dont have columns (reating one columns of dates)

and at pivot the rows and getting into levels,

any idea what to do? thanks

Re: How to create a table with columns & rows which is not pivot

Greg_Deckler — Sun, 04 Aug 2024 13:07:27 GMT

Anonymous Not quite sure I understand this. Maybe try a Matrix visual though.

Re: How to create a table with columns & rows which is not pivot

Anonymous — Sun, 04 Aug 2024 14:47:51 GMT

It wont work

As matrix visual will create one row and the next one will be in hiercachy when Im looking for different rows

Re: How to create a table with columns & rows which is not pivot

Sri_phani — Sun, 04 Aug 2024 18:46:55 GMT

Hi Anonymous If I understood your concern correctly. You are looking for stepped layout in matrix visuals. Which will add new columns instead of hierachy view . Try turning off stepped layout in matrix visual.