Forum Discussion
Display Multiple Columns Embedded within each Record
Anonymous
In order to use any visual in Power BI, you need to first organize your data. As per the screenshot, you seem to have Product and Country appearing only in the 1st row of each set of records. In that case, you can use Power Query to apply Fill-down. I suggest you share your sample in a format that can be understood and used, maybe you can attach an excel file.
Yes Fowmy , I understand that. However, this doesn't achieve what I'm looking for. The reason each product/country only appears once is because it is merged and centered in Excel. I provided this screenshot as an ideal visual scenario. It applies to each of the 3 rows.
I don't want the other rows such as country and product to repeat 3 times in the visual, this is what I am trying to avoid as it's a lot of data duplication.
Thanks
Anonymous
If you need to achieve what you have in the screenshot then it's possible but the numbers will be converted to text, meaning. is that alright?