Forum Discussion
Deneb Custom Visual - View X Axis when scrolling on Y axis
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