topic Power BI custom visuals using Charticulator - issues with slicer and legend in Custom Visuals Development Discussion

Power BI custom visuals using Charticulator - issues with slicer and legend

malpani — Tue, 03 Jan 2023 13:03:06 GMT

Hello Experts,

For my organization, I created a custom visual using Microsoft Charticulator app where I need to show Product Release and its milestones on timeline view.
I know it could be presented in other ways using default visuals but we require exactly same look and feel for our usage. So, I created this custom visual.

I completed most of it but I am stuck with couple of things mentioned below -

Charticulator doesn't work well with page slicers. I have data for 2 years - 2022 and 2023. If I select All options from dropdown it shows correct data but if I select only one year 2022 then it doesn't show correct milestones milestones during that period.

I have two kind of release milestones - MR (represented using circles) and FP (represented using triangle shape). I would like to create a legend in charticulator to show what these different shapes mean. I tried but it is not workin.
I would like to have a one more data axis at bottom or top to show year, so that user can see what was there in 2022 and what is forecasted for 2023. I tried creating additional data axis but it cannot be co-related with rest of the data - Year/Month view.

I was not aware of this custom visual community so earlier I posted same question on PBIUG, link mentioned below -

Power Bi custom visual using Charticulator | Power BI Exchange (pbiusergroup.com) .

I could not find the way to attach files here, you can find the attachments on the PBIUG thread mentioned above.

Please also let me know in case this is not the right community and pls redirect to correct community.

Request quick help to create this custom visuals.

Also, if it cannot be done using charticulator which other low code app could help to achieve this.

Can we export code from charticulator and use this in Deneb and just modify the code there.

Re: Power BI custom visuals using Charticulator - issues with slicer and legend

malpani — Tue, 03 Jan 2023 20:30:30 GMT

Hi,

Now I manage to solve most of my issues.

- Earlier I was creating charticulator visual inside PBI desktop which is then not working properly with slicers. So, then I created this first in Charticulator App and then imported template in PBI desktop. This somehow solved the problem of alignment of slicers.

- Second I wanted an additional X axis. Now I managed to do that using additional Plot area. However, I could not manage to centre align Year X axis based on Year Month Axis which I am trying to figure out.

- Third legend showing different shape for MR and FP. This I could not solve, so I artificially created this in PBI desktop using shapes and text. As this is kind of fixed, so this works for me.

Thanks.

Re: Power BI custom visuals using Charticulator - issues with slicer and legend

giammariam — Tue, 03 Jan 2023 21:45:09 GMT

I was going to take a stab at this using Deneb. It's a cool visual. Glad you found a solution.

Re: Power BI custom visuals using Charticulator - issues with slicer and legend

malpani — Wed, 04 Jan 2023 08:38:12 GMT

Hi @giammariam

Thanks, yes it was very interesting to learn and develop my first custom visual.

It would be still interesting to explore if Year can be centre aligned to Year/Month and if we can have shape based legend (circle and triangle) in charticulator.

Also, I would like to learn Deneb as Charticulator has limited support now from Microsoft; so if please share if you have any links to start my journey on Deneb.

Re: Power BI custom visuals using Charticulator - issues with slicer and legend

giammariam — Wed, 04 Jan 2023 12:58:57 GMT

@malpani, here are some of my go-to resources

There are a bunch more out there, but the resources above and the examples that they contain should keep you plenty busy.

If you ever have any questions or want to bounce off ideas, feel free to message me. I'm always up for getting in some practice