Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am new to Power BI and am trying to create a report from a large Excel file imported.
Many of my columns have data delimited by commas.
e.g.
Product ID - 1234
Locations - US,China,Australia
Colors - Blue, Green, Black, White
I need some graphs in my report to be be based on individual locations and colors. For e.g. color wise sales reports and location wise sales reports.
I could split the columns into rows but then I fear I may have to struggle with other simple graphs where unique product values are required.
Any suggestions please. Thanks in advance.
Solved! Go to Solution.
Hi,
You should defenitely split data into rows - that is the correct action to perform.
Hi,
You should defenitely split data into rows - that is the correct action to perform.
Check if this can help
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |