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.
To reproduce:
Create a Matrix. Set all data items as Rows.
Result: URLs are clickable links.
Expected result: URLs are clickable links.
All ok so far
Move the URL field to the Values area
Result: URLs are not clickable links.
Expected result: URLs are clickable links.
Is this intentional and desirable behaviour?
I am probably misunderstanding the intention of Matrices but for me it would be good for the URLs to maintain their clickability as Value items.
Solved! Go to Solution.
I'm pleased to report that the issue of URLs becoming not-clickable when moved to Values has been fixed. Not sure when the fix came through but in my current version (Version: 2.56.5023.942 64-bit (March 2018)) the URLs are now clickable whether as Rows or Values. Thank you MS Dev team!
I'm pleased to report that the issue of URLs becoming not-clickable when moved to Values has been fixed. Not sure when the fix came through but in my current version (Version: 2.56.5023.942 64-bit (March 2018)) the URLs are now clickable whether as Rows or Values. Thank you MS Dev team!
@KarlinOz and if you drag the url into the rows rather than value>?
Proud to be a Super User!
@KarlinOz which makes sense to be because its a text value, not a measure, ideally i think a measure is what is used in the values areas ideally. Is the reason you want to use due it the formatting?
Proud to be a Super User!
Uh, ok @vanessafvg thx for the clarifiction. Two reasons - aesthetically having the URL in the Values area gives a dividing line between my grouping data and my actual values and as we have very little control over appearance it is a way of making it look better. I have simplified my matrix, URL is only one of the field values I have in the visual and they are grouped by the other two fields in the Rows area. That takes me to my other reason - functionality - as far as I can tell, in the matrix we group by items in the Rows area and our actual data values are in the Values area. Something tells me that the way I am trying to do it should be functionally correct. However I stand to be corrected if I'm not understanding it.
@KarlinOz in my opinion the values area is for measure type date that gets aggregated therefore it doesn't hold the usual textual functionality which you are expecting.
so in my opinion functionally you can put it there but because its not intended for text data it probably doesn't have textual funtionality which is what comes with the url requirement
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-hyperlinks-in-tables/ hae you seen this page, not sure if this adds any value to helping
Proud to be a Super User!
@vanessafvg thx for the link, I hadn't seen it before but it doesn't add any clarity for me sadly.
I know what you are saying, yes there is aggregation because of the grouping, however we are provided with textual aggregation tools = 'First' and 'Last' so I was hoping textual functionality may be preserved. In my case there is only one row of data in each group.
And having said that my data has only one row per group when I look at the two screenshots I posted it certainly does not look that way. It's getting late here so tomorrow I'll go back to my model and re-check that.
Ok so in actual fact each group in my model actually does have only one row of data - in my first screenshot above I was showing 5/8 of the way down my data but in the 2nd shot I was at the top (see the viewport slug at the right of the pane).
So, here is another screenshot, including my additional fields and at the same point in my data, it highlights several issues I am having with the current matrix:
One possible solution I looked at was moving the URL field over to the Rows area however that gave me totals for every single URL - I need to do some experimentation to see whether I can control that.
I believe I have a work-around for 1 out of 3 of my issues:
April, 2019 version of Power BI...struggled to find a simple solution to suppress column substotals where it has 'First [fieldname]' or 'Last [fieldname]' for text fields that I don't want to show. Sadly, "hiding" the subtotal value by making it blend in with it's background seems to still be the only solution. Update on 'how to' for April, 2019 release:
1. Visualitzations Pane ->
2. (select roller paintbrush icon)
3. Field Formatting ->
4. (Select appropriate field, e.g., 'First Project Name' in dropdown) ->
5. Match font and background color
6. Ensure sliders for 'Apply to header', 'Apply to total', and 'Apply to values' are off and 'Apply to subtotals' is on.
I would obviously love to have actual control over the total removing, but this work around for hiding the total for a particular column worked perfectly for me!!!
Yes, due to formatting because a clickable link is... well useful because the URL cannot even be copied out to paste into a browser when it is plain text.
@KarlinOz what i mean is why can't you put the url in the rows on the matrix if it is clickable there? you dont have to have something in the values area
Proud to be a Super User!
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 |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |