Visualization 1 Column with several variables

Question

VisualizationHello!My propably simple (beginner) problem is this in the screenshot.It is 1 column with several variables with a semikolon as space between them.But i want to have the visualization show the total amount of As Bs (...).Is there an easy way to do this?Help is appreciated! Thanks!&nbsp;

amitchandak · Answer

Anonymous , Better to split the column into rows in Power Query 
Refer: https://www.youtube.com/watch?v=FyO9Vmhcfag
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

anonymous · Answer

I have done that and it works now in a 90% way.The problem is as shown below the single values are split in between themselves from the 4 splitted columns. Can you help me with this?Thanks already!B

anonymous · Answer

HiAnonymous，&nbsp;I'm not sure if I understand your needs accurately ，sample data (without sensitive data )and expected output would help tremendously.Please see this post regarding How to Get Your Question Answered Quickly:https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490&nbsp;&nbsp;Best Regards,Caitlyn Yan&nbsp;&nbsp;&nbsp;

Forum Discussion

Visualization 1 Column with several variables

3 Replies

Related content

Slicer for filtering several columns

Variable still filtered in visual where using REMOVEFILTERS

Creating a visual using several filters

A global variable usable by several reports

Export several table visuals from a workspace