Custom Icons within Dax Measure returning Text.
Hi, I am working on a report for accessing information about uploaded documents (via MS Forms). I created a measure, that depending on the row level, will either give us the name of the file with a conditional icon (they are added to the json theme) that reflects that file's extension, or a Sharepoint Icon, and a count of different files + Count of file types. This is the measure: Document Title* = VAR _List = CALCULATE(CONCATENATEX(DISTINCT('fact_OfficeForms Table'[Extension]), 'fact_OfficeForms Table'[Extension],", ")) VAR _FileTypeCount = DISTINCTCOUNTNOBLANK('fact_OfficeForms Table'[Extension]) VAR _Result = IF( HASONEVALUE('fact_OfficeForms Table'[ID]), SELECTEDVALUE('fact_OfficeForms Table'[Document Title]), IF( COUNT('fact_OfficeForms Table'[ID])=0, BLANK(), DISTINCTCOUNTNOBLANK('fact_OfficeForms Table'[ID])&" documents uploaded. "& _FileTypeCount& " file type(s) : " & _List ) ) RETURN _Result In the case where there are multiple files in the row level context, instead of simply listing the file type extensions I would like to list the icons, like this: But I don't know if it is possible to use Icons that way, in text (not in conditional formatting). Any help would be much appreciated! Best regards, Mike.
Tips on displaying icons based on field values in Power BI
When exploring and analyzing data, we may need to add colored icons to help us visually identify patterns and trends. Currently, there are two main ways to add icons. 1. Icon sets for conditional formatting a) built-in icon sets b) custom icon sets (json file of theme) 2. Conditional fields a) SVG xml, Img URL, Built-in icon name b) Html-code of Unicode characters
Custom Theme Icons Not Working
We're trying to use a custom theme with custom icons in PBIRS Desktop October 2020 but the icons are not showing under conditional formatting after successfully loading the theme. We've created our own JSON files but have also tried a well know theme file from PowerBi.Tips https://powerbi.tips/product/theme-file-with-icon-set/ Anybody else had the same issue or any idea where to start to look to fix it?
How to change report server (Sept 2021 release) folder Icon color
After playing around with the branding package, I don't see an option to change the report server (Sept 2021 release) folder icon color. I think the next step might be some developer tools logging to understand the object properties. Example, change the blue color below: I'm curious if anyone else has manipulated folder, report, data source icons?
Plugin Icons not showing in Leaflet using R
Hello, We have a need to use a mapping solution in PowerBI embedded. Since neither of ArcGIS or MapBox works for us, we are creating a mapping custom visual using Leaflet and R in PowerBI. For the most part, the visual works fine, but whenever we are trying to add a leaflet plugin, the icons for the plugins do not show up in the visual. Here's how the 'Measure' plugin should look (RStudio) And here is how the icon looks in PowerBI visual I'm really not a coder and certainly not conversant with .js, hence our inclination towards using the Internactive R visuals to create the Leaflet visual. Making custom Interactive R visuals with PowerBI indeed opens up a host of possibilities in PowerBI. Any help on how to rectify the issue is most welcome. Best Regards, Jigar
