SVG icons in matrix not showing up
Hi all, I need some help with my matrix. For the matrix outlined in pink, the SVG icons do not show up 😞 The column [svg_url] has values formatted like this : "data:image/svg+xml;utf8," & "<svg fill='#4E8BA1' width='800px' height='800px' viewBox='0 0 1920 1920' xmlns='http://www.w3.org/2000/svg'><path d='M213.333 960c0-167.36 56-321.707 149.44-446.4L1406.4 1557.227c-124.693 93.44-279.04 149.44-446.4 149.44-411.627 0-746.667-335.04-746.667-746.667m1493.334 0c0 167.36-56 321.707-149.44 446.4L513.6 362.773c124.693-93.44 279.04-149.44 446.4-149.44 411.627 0 746.667 335.04 746.667 746.667M960 0C429.76 0 0 429.76 0 960s429.76 960 960 960 960-429.76 960-960S1490.24 0 960 0' fill-rule='evenodd'/></svg>" The data category is set as Image URL I've had success with the matrix outlined in yellow (using http links), but wanted to use a different method for linking svg icons as I wanted fuller control over the icons' colour. I've also tested out the same values using a DAX measure [svg_url_DAX] and displaying it as a table (outlined in green), it shows up just fine, I wonder what went wrong. 😬 Link to .pbix file + svg icons : https://drive.google.com/drive/folders/1d_6_pT5TJtg5KpRC79plvzXfako83upA?usp=sharing Appreciate any help and pointers! Much thanks!
Hierarchy in matrix visual: blank rows
Hi everyone! I have a hierarchical tree of departments and i would like the show the processes_id in each unit like that using the matrix visual. The strings in the format xxx-yyyy are the processes id that are in each unit. It's working amost well except the blanks rows 😞 I would like to know if there is way not showing the blank rows. The option 'Show items with no data' is unchecked. In 'rows' i put the four levels and the process_id. The pbix file is here! Thanks for any help!
How to create a dynamic legend for matrix based on quarter selected
Hi I have a matrix visual that has % of Approved Request by Divison by Quarter. How can i make the quarter Dynamic? where it will show the current and previous 3 quarters based on the quarter that I have selected. I already have the measures for Current Quarter, and 3 quarters prior, but i am unable to make it dynamic.
Coloring cells / columns based on standard deviation of window values
Hi, I am working on moving some of our dashboards from Tableau to PowerBI, but I am struggling to find a way to do this. I have the margin of multiple products, and I want to compare it for different regions. I want to highlight those regions performing well and those underperforming. How can I do something similar in PowerBI? (Below is the tableau equivalent). Thanks, Daniel This is the view I have in Tableau Where Profit % = SUM(Profit) / SUM(Sales) and Color = IF ([Profit %]) > (WINDOW_AVG(([Profit %]))+0.75*WINDOW_STDEV(([Profit %]))) THEN "Green" ELSEIF ([Profit %]) < (WINDOW_AVG(([Profit %]))-0.75*WINDOW_STDEV(([Profit %]))) THEN "Red" ELSE "Neutral" END
Decimal change to Whole number not working in Matrix
Hello helpers, I have dataset orginally build as Decimal (10,2) format numbers, after i loaded to Power BI, i changed the number to Whole Number, Now the dataset shows as whole number fine, but the numbers in visuals still show 2 decimal 0s. And when i select the column, it shows as Whole number Formatting: Dataset: Display in Matrix Any suggestions please? Thank youDoes anyone have a working example of the Customized data reduction capabilities in a matrix?
Hi all I'm trying to set this up for a matrix visual following the documentation here: Customized data reduction but I can't seem to get it to work. I've updated my project to use API 5.2 and I've updated the capabilites file with the exact code from that page but the properties don't appear in the format pane. Does anyone have an example of this working? ThanksSeeking help to recreate a table/card
Hi Community, I am trying to recreate a--very simple--scorecard for a client. This client creates a scorecard in Excel and I am attempting to recreate, verbatim, what they have created. I am struggling to find what I should use. I have tried a table, matrix and a kpi tile to no avail. Can anyone help guide me to what visual would be best to provide the below? Thank you!
