https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-get-two-separate-rows-for-the-fields/m-p/3001406#M101350 <P>I tried this but still not able to get the rows in two seperate rows.</P> Wed, 04 Jan 2023 15:56:43 GMT asdf1608 2023-01-04T15:56:43Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-get-two-separate-rows-for-the-fields/m-p/2998726#M101145 <P>I need the category and city to be in two seperated columns instead of in icons.&nbsp;</P><P>If I remove the - icon then like the below picture comes</P><P><img /></P><P>The category hierarchy should be expanded/contracted. But the city should be in seperate row.</P><P>For example should be like this(possible in tableau)</P><P><img /></P><P><img /></P><P>&nbsp;</P><P>Is this possible through power BI?</P> Tue, 03 Jan 2023 13:58:26 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-get-two-separate-rows-for-the-fields/m-p/2998726#M101145 asdf1608 2023-01-03T13:58:26Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-get-two-separate-rows-for-the-fields/m-p/2998839#M101153 <P>Try to Toggle on Vertical gridlines (with light grey color) of the Grid.</P> Tue, 03 Jan 2023 14:47:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-get-two-separate-rows-for-the-fields/m-p/2998839#M101153 Anonymous 2023-01-03T14:47:42Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-get-two-separate-rows-for-the-fields/m-p/2998866#M101158 <P>I didn't get it. Can you explain in detail?</P><P>&nbsp;</P><P>Thanks in Advance</P> Tue, 03 Jan 2023 15:02:19 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-get-two-separate-rows-for-the-fields/m-p/2998866#M101158 asdf1608 2023-01-03T15:02:19Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-get-two-separate-rows-for-the-fields/m-p/3001237#M101333 <P><img /></P><P>&nbsp;</P> Wed, 04 Jan 2023 14:35:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-get-two-separate-rows-for-the-fields/m-p/3001237#M101333 Anonymous 2023-01-04T14:35:36Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-get-two-separate-rows-for-the-fields/m-p/3001406#M101350 <P>I tried this but still not able to get the rows in two seperate rows.</P> Wed, 04 Jan 2023 15:56:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-get-two-separate-rows-for-the-fields/m-p/3001406#M101350 asdf1608 2023-01-04T15:56:43Z