I am struggling with a Deneb side-by side visual with a shared Y axis. I have gotten everything to work properly except for the highlighting. I know that I need the below code, but I have tried to figure out where and I am at a lost. I have attached a link to the PBIX. Can you please help me? Thank you!
(I didn’t have any issues with your original link; Box asked me to download the file first and it then opened without issue … not sure what the issue was …)
I’m not sure what the issue was with implementing highlighting in your existing Deneb/Vega-Lite code, but after a couple of short and failed attempts to modify it, I created a new visual from scratch that was much simpler and everything worked fine.
As a first point, the recommended method to implement highlighting is with two overlapping marks; the background mark with reduced opacity and the foreground mark with conditional opacity (if __selected = on then 1 else 0). See the Deneb website for more details.
Regardless, here’s what I came up with (I didn’t spend any time matching your formatting … just created a working visual).
A few notes:
you don’t need to use aggregates; Power BI has already aggregated the data
you don’t need to use the “resolve” block; Vega-Lite resolves the same Y axis for all by default
the original visual only had 1 bar mark per section (e.g., Requests), where 2 marks are recommended for highlighting
Greg, thank you! Oh my goodness. I will work on getting the tooltips back on.
Yes, I know that the left version in the file only had the one mark. Every time I tried to add the second, I couldn’t get the highlighting to work, so I kept going back to the version without highlighting and starting from scratch (again and again and again). Later in the day, I added a version that had two marks in the last column so I could show what wasn’t working. Not sure if you were so speedy and saw the first version or not.
you know that you can upload directly into edna forum using the upload button within the message box instead of applying to box which i could cannot get too.
@Greg Unfortunately, when one of my values is null, then it doesn’t keep a placeholder in the y-axis. For example, I replaced the Amt Recommended in Power Query of $3,400,000 with null and then only three bars showed up for the two amt rec metrics. Any thought as to how to resolve that?
This thread has already been solved. It is discouraged on this forum to reply to a solved thread. Please instead create a new thread for each new question.
Regardless, simply replace the null value in your Deneb/Vega-Lite code using a “calculate” transform and, if desired, filter-out the undesired label.
