topic Re: Deneb Custom Visual - View X Axis when scrolling on Y axis in Developer

Deneb Custom Visual - View X Axis when scrolling on Y axis

malpani — Mon, 20 Nov 2023 18:13:23 GMT

Hi Experts,

I previously prepared a visual with Charticulator but since it is discontinued, I am trying to create same visual as shown below with Deneb Vega Lite.

1. First and priority problem which I am trying to solve is scrollig on X and Y axis.

I have now scrolling enabled on Y axis but issue is, when I scroll up on Y axis the X-Axis dissapears and I can,'t see the Month-years on X axis. Can this X axis be frozen, so it visible when scrolling up ?

I refered to the post available on link - Solved: Deneb Freeze X Axis in Gantt Diagram - Microsoft Fabric Community. @giammariam I understand there is no way to make X axis visible while scrolling on Y axis.

So, I tried alternate suggested by @ppm1 here - https://www.youtube.com/watch?v=lmC5k12jd_Y .

I managed to get scrollbar but I could not get window of 20 products and also zoom by scrooling on X axis.

2. Second problem I had is that sometime milstones dates are in same month so in visual they overlap. In charticulator, there was a way to vertical or horizontally split for overlapped values. I dont know how this can be done in Deneb.

I really appreciate if there is any other alternates available for user friendly scrolling.

I have uploaded PBIX file with visual and code and datasource excel on the drive -

https://drive.google.com/drive/folders/1PUCYaMXS5bj0-Y7SeLz4PwZekU9Gv2O-?usp=drive_link

@ppm1 , @giammariam , @lbendlin

Re: Deneb Custom Visual - View X Axis when scrolling on Y axis

lbendlin — Thu, 23 Nov 2023 00:26:03 GMT

I understand there is no way to make X axis visible while scrolling on Y axis.

have you tried using vconcat with the top container suppressing the x axis and the bottom portion only showing the x axis (with a fake 0 value) ?

Re: Deneb Custom Visual - View X Axis when scrolling on Y axis

malpani — Thu, 23 Nov 2023 05:27:05 GMT

@Ibendlin: Thank you so much for looking into this thread. I was eagerly waiting for the response.

This is my first attempt to Vegalite. And I dont much about using vconcat, container concept. I created current looking at the templates of vegalite.

So, do you mind adding few lines to the existing code or point me to any existing template pls.

Re: Deneb Custom Visual - View X Axis when scrolling on Y axis

lbendlin — Fri, 24 Nov 2023 21:42:33 GMT

I'm not an expert either, still learning Deneb. Maybe @dm-p has some advice.

Go through their examples, try with something simpler first. Once you have mastered the "same X axis but hidden on the top container" then you can modify the code for your Gantt chart accordingly.

Re: Deneb Custom Visual - View X Axis when scrolling on Y axis

malpani — Tue, 28 Nov 2023 19:07:24 GMT

I partially managed to solve the problem. Now I have added a Scroll Bar brush for Y axis and I have also fixed that with each +1 step scrolled on Y axis it will only show 10 rows on Y axis. This is now working as desired.

"params": [ { "name": "ScrollBar", "value": 1, "bind": { "input": "range", "min": 1, "max": 100, "step": 1 } } ],

To make it work I have created a 'Rank' measure which creates dynamic Indexing post filtering of data using slicers on the page.

Rank = RANKX(ALLSELECTED('DPM dump_Jan2023'), CALCULATE(SUM('DPM dump_Jan2023'[Index_ProductRel])), , ASC, Dense )

Sample PBI with dataset is available on same link - https://drive.google.com/drive/folders/1PUCYaMXS5bj0-Y7SeLz4PwZekU9Gv2O-?usp=sharing

But still I am facing one problem in passing dynamic value to max of the scrollbar which is currently set to static value of 100.
I would like to make this value dynamic based on Rank column (Max of Rank Column).

I created one more measure in PBI to calculate Max of Rank Column but not sure why but I am not able to pass that measure to this max of ScrollBar.

MAX_Rank = MAXX(VALUES('DPM dump_Jan2023'),[Rank])

I tried using expr and joinagreegate to trasform, calculate and then pass the value to max but its not working.

Request your expertise to pass either a measure or calculated value to max of scrollbar.

@lbendlin, @giammariam @ppm1 @dm-p