Idea: user defined visual calculation functions to embed charts into Matrix/Table visual

[avatorl]

I have an idea. But it needs 1 million votes on the ideas website to be implemented. Vote and promote the idea, if you like it.

User defined visual calculation functions

Now, to make such visualization in a matrix visual and to avoid code duplication in every visual in a report I use a calculation group to generate SVG images. To configure the solution I have to edit multiple calculation group items to define what fields and measures will be used in different visuals (based on a measure name).

The idea is to be able define a custom visual calculations function (something like a measure with parameters) instead. Then you will write a simple visual calculation:

New Column = UDF_SVG_ABSOLUTE_VALUES ([Sales], PREVIOUS ([Sales])

[Sales] and previous year [Sales] parameters will be passed into the function to generate SVG code of the chart with of two columns: black for [Sales] and grey for previous year [Sales]. So the result of UDF_SVG_ABSOLUTE_VALUES ([Sales], PREVIOUS ([Sales]) function is what you see in column AC,PY on the image.

Similar approach to generate 2 other columns with charts (just use different user defined functions).The code of the user defined function will be simple: it's just about converting input parameters (sales in the example) into the SVG rectangles. Also you'll be able to make custom functions that generate any SVGs you want.

Imagine, you can do this:

https://www.dropbox.com/scl/fi/6hlegg26bjg3atygs6jzt/PBIDesktop_dyxVyjg3MA.mp4?rlkey=9z7c9gaeky65v5l...

Vote for the idea: https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=b66e3777-0972-ef11-a4e6-000d3ae47b7b

[Anonymous]

Hi,@avatorl .I am glad to help you.

I think you and the team have come up with a very creative idea that aims to simplify and enhance visualizations in Power BI through user-defined calculation functions (UDFs).

In order for this idea to be realized, you mentioned that you need to get enough votes on the IDEAS website to support it. You can can promote it through social media, emails, etc. to make more people aware and support the idea.

Here are some of my suggestions. If your idea turns out to be a fact, you can get it certified by Microsoft through a series of ways below.
URL:

Get your Power BI visuals certified - Power BI | Microsoft Learn

I recommend that you accept your idea as a solution, so that when other users have a similar idea for quickly find the need for ideas, through the link you give, for you to cast a valuable vote, so that your ideas from the realization of a further step.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.