Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Its been a while since this Visual Explorer by @alex-potter
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-Appl...)
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
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
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
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"
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/
Added a few tweaks.
PowerBI/R Visual Types
Certified on Lists
Github Links
and refresh time
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.
@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.
Fixed the other github entries and added a manual list for any without the link in the description.
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 🙂
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.
Excellent! Thank you!
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.
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.
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!
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
)
Love the use of the new visuals that have been added since the one I made.
Looks great!
Alex