The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hi all!
Currently I am developing a custom visual for one of my clients. One of the features that I need is to drilldown on click of a data point. A behavior like the "histogram" default component would be perfect (the user can select data, then if [s]he clicks on "drill mode" can drill down contextual data).
Trying out the sampleBarChart component from the Microsoft's tutorial, I get a strange behavior:
- In PowerBI Desktop everything works as expected.
- In PowerBI Online (IE11/FF/Chrome) it does nothing.
Strangely enough, if I manually force the refresh of the data (by for example resising the visual - edit mode only) I get the right data! For this reason I guess a possible workaround would be a simple refresh... But AFAIK it is not possible to trigger a refresh on a visual by code...
I am attaching a pbix with a dumb dataset to reproduce the issue. I had to enable drilldown on the sampleBarChart visual: I simply added
"drilldown": { "roles": ["category"] },
in the capabilities and built it.
Can anybody help?
Attachment:
- PBIX (I could not upload it here...) https://www.sendspace.com/file/1oo07q
Solved! Go to Solution.
One last note: with the new update of PBI Desktop, the offline behavior matches the online one.
Meanwhile, the related issue has been accepted.
Thank you for you support,
Marco
Hi! Thank you for you answer!
Checking thoroughly the behavior of the visual, I managed to get the same behavior using just the drilldown controls (nothing custom at all this time: no selection, no contextual drilldown, no events on my custom visual fired... And no refresh until resize!). It seams to me much more like a bug than a limitation. I made a quick scheme of what the behavior I get and I attached to this message.
As you can see, when I expand to the next level, the controls and the title understand the change and are able to update, but the data isn't. I get no update event (I am logging every event). Moreover, clicking "update" has no effect on the visual (once it gets in that state it is "stuck" there until resize: I get no "update" event), while in a normal situation (and also after resize) I get normal events on "update" as well.
I have written in the "issue" section of this community website this problem, but since last ticket did not have any answer (almost a month old.. ) I am not sure it will be useful...
PS: I also would like to note that (ironically ?!) in PBI Desktop the behavior is reversed (on resize, I get the wrong data!).
One last note: with the new update of PBI Desktop, the offline behavior matches the online one.
Meanwhile, the related issue has been accepted.
Thank you for you support,
Marco
User | Count |
---|---|
6 | |
4 | |
3 | |
3 | |
2 |
User | Count |
---|---|
9 | |
7 | |
6 | |
5 | |
4 |