Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
We have a simple product list on SPO (Sharepoint Online) with this cols:
- titel
- picture (URL)
- property a (text)
- property b (number)
- property c (date)
...
- property z (Yes/No)
Now i want to show the selected products in a product-matrix!
I unpivot all columns except 'title'
If i change the data-cathegory for the resulting 'Values"-column to 'Image URL' i can see the product picture in the matrix but not the other properties and vice versa.
Is there away to preserve the format/data category of the columns after unpivoting?
Thanks for helping me.
Johannes
Solved! Go to Solution.
Hi@ gaj
After my research, you can use sort by function and do these follow my steps like below:
Step 1:
Rename column in Edit Queries
Format: ’decimal number’+’ ’+’title’
I recommend use ‘ ’ as delimiter
For example
Be care for that there is one ‘ ’ between ’decimal number’ and ’title’
Step 2:
Unpivot columns
Step 3:
Select column Attribute and then click Add Column->Extract->Text Before Delimiter
Entry “ ” click OK
Step 4:
Change the type of column Text Before Delimiter to Decimal Number and then Click Close&Apply
Step 5:
Drag fileds into table then select filed Attribute click Modeling->Sort ->Sort by Column -> Text Before Delimiter
Result:
Best Regards,
Lin
Hi@ gaj
After my research, you can use sort by function and do these follow my steps like below:
Step 1:
Rename column in Edit Queries
Format: ’decimal number’+’ ’+’title’
I recommend use ‘ ’ as delimiter
For example
Be care for that there is one ‘ ’ between ’decimal number’ and ’title’
Step 2:
Unpivot columns
Step 3:
Select column Attribute and then click Add Column->Extract->Text Before Delimiter
Entry “ ” click OK
Step 4:
Change the type of column Text Before Delimiter to Decimal Number and then Click Close&Apply
Step 5:
Drag fileds into table then select filed Attribute click Modeling->Sort ->Sort by Column -> Text Before Delimiter
Result:
Best Regards,
Lin
Hi Lin,
Now i have a nother problem with the Images. If I publish the report to a ppublic URL everybody with the URL can see the images.
If I use the report in MS Teams or in SPO in a modern site only the Admin can see the images, also the same in Power BI Webclient and Power BI Windows Client.
I have stored the images in an SPO picture library (because i want to use the rendition-options).
Can you help me?
thx.
Johannes
Sorry,
If I integrate Power BI in SPO on a modern site the images are shown, but not in MS Teams!
Hi Lin,
Thank you, works fine
My workaround:
unpivot all cols except picture-URL-col (picture is in first row/header)!
Is there a way to sort the pivoted cols ? I tryed renaming (1. foo, 2.1 foo.. but after 9 problem!) the cols befor unpivoting.
thx.
Johannes
Hi@ marksappleton
After my research , I'm afraid it couldn't achieve in Power BI for now , Maybe you can try to unpivot all columns except 'title' and 'picture'
and then set the data-cathegory of the column ”picture” to 'Image URL' individual.
Then drag fileds into matrix.
Result:
Reference:https://blog.gbrueckl.at/2018/01/storing-images-powerbi-analysis-services-data-models/
Best Regards,
Lin
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
63 | |
63 | |
53 | |
39 | |
25 |
User | Count |
---|---|
85 | |
57 | |
45 | |
43 | |
38 |