Its been a while since this Visual Explorer by Anonymous https://community.powerbi.com/t5/Data-Stories-Gallery/Power-BI-Custom-Visuals-Explorer/m-p/187266 stopped working so I decided to build a new version. You can filter using a variety of fields. There are 2 main pages for one for all and and another recent updates. You can drill through to a publisher page or the visual details. Follow me on twitter https://twitter.com/StretchArm1 for updates Other gallery entries PowerBI/SQL Server and Microsoft Business Application Related YouTube Videos https://community.powerbi.com/t5/Data-Stories-Gallery/PowerBI-SQL-Server-and-Microsoft-Business-Application-Related/m-p/743806#M2779) SQL Saturday Sessions https://community.powerbi.com/t5/Data-Stories-Gallery/Pass-SQLSaturday-Dashboard/m-p/489529#M2153 Microsoft Bus App Summit & SQL Bits videos https://community.powerbi.com/t5/Data-Stories-Gallery/Search-Microsoft-based-Business-Application-videos-and/m-p/714344#M2679 and for any SSIS users https://community.powerbi.com/t5/Data-Stories-Gallery/SSIS-Catalog-DB-Dashboard/td-p/244677 Most code is also here https://github.com/stretcharm eyJrIjoiNTUyNGQ5YWEtNDFhNi00ZmM2LTk3NzItOWRlNTQxZmM4ZjkyIiwidCI6ImEwYTcyYzIzLTdlMWEtNGYxOC05NDU4LTlhNzUyYTEzMTg1NCJ9

I use a Dax table. I create small summaries of the fields I want and then union the results. I then connect to the main table that I'm filtering. I have to use bidirectional filters otherwise the facet filters don't work. Originally I did this in M but its much faster and simpler in Dax. Facets = VAR _Category = SELECTCOLUMNS ( ADDCOLUMNS ( SUMMARIZE ( Categories, Categories[Tag], Categories[Code] ), "Category", "Category", "Style", "fa fa-bars" ), "Category", [Category], "Style", [Style], "Tag", [Tag], "Code", [Code] ) VAR _Rating = SELECTCOLUMNS ( ADDCOLUMNS ( SUMMARIZE ( GetPageEntries, GetPageEntries[Rating], GetPageEntries[Code] ), "Category", "Rating", "Style", "fa fa-star" ), "Category", [Category], "Style", [Style], "Tag", [Rating], "Code", [Code] ) VAR _Publisher = SELECTCOLUMNS ( ADDCOLUMNS ( SUMMARIZE ( GetPageEntries, GetPageEntries[Publisher], GetPageEntries[Code] ), "Category", "Publisher", "Style", "fa fa-windows" ), "Category", [Category], "Style", [Style], "Tag", [Publisher], "Code", [Code] ) VAR _New = SELECTCOLUMNS ( ADDCOLUMNS ( SUMMARIZE ( FILTER ( GetPageEntries, GetPageEntries[New]<>"" ),GetPageEntries[Code]), "Category", "Tag", "Style", "fa fa-new", "Tag", "New" ), "Category", [Category], "Style", [Style], "Tag", [Tag], "Code", [Code] ) VAR _Certified = SELECTCOLUMNS ( ADDCOLUMNS ( SUMMARIZE ( FILTER ( GetPageEntries, GetPageEntries[Certified]<>"" ),GetPageEntries[Code]), "Category", "Tag", "Style", "fa fa-certificate", "Tag", "Certified" ), "Category", [Category], "Style", [Style], "Tag", [Tag], "Code", [Code] ) VAR _Price = SELECTCOLUMNS ( ADDCOLUMNS ( SUMMARIZE ( GetPageEntries, GetPageEntries[Price], GetPageEntries[Code] ), "Category", "Tag", "Style", "fa fa-dollar" ), "Category", [Category], "Style", [Style], "Tag", [Price], "Code", [Code] ) VAR _VisualType = SELECTCOLUMNS ( ADDCOLUMNS ( SUMMARIZE ( GetPageEntries, GetPageEntries[Visual Type], GetPageEntries[Code] ), "Category", "Tag", "Style", "fa fa-signal" ), "Category", [Category], "Style", [Style], "Tag", [Visual Type], "Code", [Code] ) VAR _GitHub = SELECTCOLUMNS ( ADDCOLUMNS ( SUMMARIZE ( FILTER ( GetPageEntries, GetPageEntries[Github URL]<>"" ), GetPageEntries[Code] ), "Category", "Tag", "Style", "fa fa-github", "Tag", "GitHub" ), "Category", [Category], "Style", [Style], "Tag", [Tag], "Code", [Code] ) VAR _Tag = SELECTCOLUMNS ( ADDCOLUMNS ( SUMMARIZE ( Words, Words[Word], Words[Code] ), "Category", "Keywords", "Style", "fa fa-tag" ), "Category", [Category], "Style", [Style], "Tag", [Word], "Code", [Code] ) RETURN UNION ( _Tag, _New, _Category, _Certified, _Price, _Publisher, _Rating, _VisualType, _GitHub )

This report is currently broken. It was written before the web by example feature was added to powerbi so it could be written much better now.This will get you all the names and some details. You have loop over the different pages. My version I did all the parsing and extracting in M so it was not the easiest to work with and is prone to failing when the site changes. let Source = Web.BrowserContents("https://appsource.microsoft.com//en-us/marketplace/apps?src=office&product=power-bi-visuals&page=1"), #"Extracted Table From Html" = Html.Table(Source, {{"Name", ".c-heading6"}, {"Author", ".provider"}, {"Ratings", ".ratingsCount"}, {"Description", ".c-paragraph-4"}, {"Code", ".tileLink", each [Attributes][href]?}}, [RowSelector=".spza_tileWrapper"]) in #"Extracted Table From Html"

Love the use of the new visuals that have been added since the one I made. Looks great! Alex

Added a few tweaks. PowerBI/R Visual Types Certified on Lists Github Links and refresh time

Thanks for this - will be very well used I suspect. What visual did you use for the main slicer? I've not seen that before but it looks good and is really functional.

PowerBI Custom Visuals | Microsoft Fabric Community

15 Replies

Anonymous
Not applicable
7 years ago
Love the use of the new visuals that have been added since the one I made.

Looks great!

Alex
stretcharm
Memorable Member
7 years ago
Added a few tweaks.

PowerBI/R Visual Types

Certified on Lists

Github Links

and refresh time
- otravers
  Community Champion
  7 years ago
  That was fast! Small bug though, you have some extra html markup at the end of your Github links that prevents them from working properly.
  - stretcharm
    Memorable Member
    7 years ago
    
    otravers wrote:
    
    That was fast! Small bug though, you have some extra html markup at the end of your Github links that prevents them from working properly.
    
    Thanks, fixed most of them. Will get a few stragglers tomorrow.
tomknight
Helper I
7 years ago
Thanks for this - will be very well used I suspect. What visual did you use for the main slicer? I've not seen that before but it looks good and is really functional.
- stretcharm
  Memorable Member
  7 years ago
  It's the Microsoft Facet Key.
  
  https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380807?src=office
  
  Yes looks nice with the use of different fonts and lets you merge multiple filters with a bit of work.
  
  Does range and sparkline stuff as well. Check the sample file from the download page.
  
  Only downside is it slower that most visuals but works well in this case.
  - GreetSmekens
    Regular Visitor
    6 years ago
    Hi,
    
    I cannot seem to merge multiple filters.
    
    Let say I want city, age and sex as facets and the respective locations, gender and age categories as instances.
    
    this to filter sportsparticipation on a shapemap.
    
    Bit similar to yoour example. But I can't add multiple facets or instances.
    
    Could you point me in the right direction?
    
    thanks!
Anonymous
Not applicable
7 years ago
Excellent! Thank you!
otravers
Community Champion
7 years ago
Well done and useful, thank you, this is appreciated.

Most of these custom visuals can also be found on Github, where more information about changes can be found (there's no changelog on AppSource), users can submit bug reports and feature requests, etc. For example:

https://github.com/Microsoft/powerbi-visuals-timeline/

It would be awesome if you could 1) add links to Github repos whenever available, and 2) retrieve data about these repos (e.g. number of commits, open and closed issues, contributors...). I realize this is more work/time which you may or may not want to commit :)
- stretcharm
  Memorable Member
  7 years ago
  I've added the github links if they are are in the descriptions.
  
  Also a tag so you can filter them.
  
  The refresh is a bit tempremental from the app website on the service so I think trying to get github data will probably break it.
mike_honey
Memorable Member
5 years ago
Can you please share the PBIX? We are trying to integrate this data with the Power BI Cleaner (community project), to add translations from Custom Visual GUIDs to CV Names and versions.

https://www.thebiccountant.com/2020/01/01/tidy-up-power-bi-models-with-the-power-bi-cleaner-tool/
mike_honey
Memorable Member
5 years ago
This looks great. Could you possibly share the PBIX?
I'm interested to integrate the data on Custom Visual names etc with this community project for PBIX documentation and analysis:

https://www.thebiccountant.com/2021/06/27/power-bi-cleaner-gen2-is-here/

TIA

Mike
- stretcharm
  Memorable Member
  5 years ago
  This report is currently broken. It was written before the web by example feature was added to powerbi so it could be written much better now.
  
  This will get you all the names and some details. You have loop over the different pages. My version I did all the parsing and extracting in M so it was not the easiest to work with and is prone to failing when the site changes.
  
  let Source = Web.BrowserContents("https://appsource.microsoft.com//en-us/marketplace/apps?src=office&product=power-bi-visuals&page=1"), #"Extracted Table From Html" = Html.Table(Source, {{"Name", ".c-heading6"}, {"Author", ".provider"}, {"Ratings", ".ratingsCount"}, {"Description", ".c-paragraph-4"}, {"Code", ".tileLink", each [Attributes][href]?}}, [RowSelector=".spza_tileWrapper"]) in #"Extracted Table From Html"