topic Re: PowerBI Custom Visuals in Data Stories Gallery

PowerBI Custom Visuals

stretcharm — Mon, 28 Oct 2019 22:45:59 GMT

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

Re: PowerBI Custom Visuals

Anonymous — Tue, 25 Jun 2019 22:33:42 GMT

Love the use of the new visuals that have been added since the one I made.

Looks great!

Alex

Re: PowerBI Custom Visuals

tomknight — Wed, 26 Jun 2019 08:22:12 GMT

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.

Re: PowerBI Custom Visuals

Anonymous — Wed, 26 Jun 2019 10:21:11 GMT

Excellent! Thank you!

Re: PowerBI Custom Visuals

otravers — Wed, 26 Jun 2019 16:33:53 GMT

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 :)

Re: PowerBI Custom Visuals

stretcharm — Wed, 26 Jun 2019 21:14:26 GMT

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.

Re: PowerBI Custom Visuals

stretcharm — Wed, 26 Jun 2019 22:45:16 GMT

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.

Re: PowerBI Custom Visuals

stretcharm — Wed, 26 Jun 2019 22:50:00 GMT

Added a few tweaks.

PowerBI/R Visual Types

Certified on Lists

Github Links

and refresh time

Re: PowerBI Custom Visuals

otravers — Thu, 27 Jun 2019 00:00:40 GMT

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.

Re: PowerBI Custom Visuals

stretcharm — Thu, 27 Jun 2019 17:19:20 GMT

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.

Re: PowerBI Custom Visuals

stretcharm — Fri, 28 Jun 2019 18:43:18 GMT

Fixed the other github entries and added a manual list for any without the link in the description.

Re: PowerBI Custom Visuals

GreetSmekens — Wed, 30 Oct 2019 14:08:40 GMT

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!

Re: PowerBI Custom Visuals

stretcharm — Wed, 30 Oct 2019 19:09:45 GMT

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 )

Re: PowerBI Custom Visuals

mike_honey — Thu, 01 Jul 2021 02:40:47 GMT

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/

Re: PowerBI Custom Visuals

mike_honey — Tue, 06 Jul 2021 11:16:28 GMT

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

Re: PowerBI Custom Visuals

stretcharm — Thu, 22 Jul 2021 12:23:22 GMT

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"