Forum Discussion

amitchandak's avatar
amitchandak
Super User
6 years ago

 Edit Query Mode (Latest version Transform Data in Home Tab)-> Use Split Column option -> Delimiter

 

Refer

https://www.newtechdojo.com/unpivot-columns-in-power-bi/

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

RanjanThammaiah's avatar
RanjanThammaiah
Helper V
6 years ago

Not sure if i am clear on my request.

 

When i do the delimiter the values are repeting with ech other and i am getting the dashboard number affected.

 

Regards,

Ranjan