topic Re: Field Parameters in Deneb Visuals in Custom Visuals Development Discussion

Field Parameters in Deneb Visuals

DW868990 — Tue, 30 Aug 2022 15:32:41 GMT

Hi,

Do field parameters work within deneb visuals?

Thanks in advance

Re: Field Parameters in Deneb Visuals

KerKol — Wed, 31 Aug 2022 08:14:09 GMT

Only partially I believe, @dm-p can awnser that

Re: Field Parameters in Deneb Visuals

dm-p — Wed, 31 Aug 2022 08:22:32 GMT

No, field parameters aren't currently supported. They don't work well in a "flexible dataset"-type situation and have to be very explicitly defined in a custom visual (which is why they work well in visuals with defined data roles).

I will be planning some limited support for field parameters in v2, and the RFC is here if you wish to add your thoughts to it or track its status. As field parameters are in still preview for Power BI, it will give sufficient time for me to review the GA implementation and bear any additional changes in mind before I start working on it, as it's quite a big piece of work.

Deneb version 2 is currently being scoped and planned, and I don't have a solid ETA yet. We may start seeing alpha builds very late this year or early next year if all goes well. I develop Deneb in my free time and free of charge, so it's hard to gauge exactly how long things can take.

Re: Field Parameters in Deneb Visuals

DW868990 — Wed, 31 Aug 2022 12:30:37 GMT

Thank you @dm-p

Appreciate the work that goes into Deneb

Re: Field Parameters in Deneb Visuals

rdavi10471a2 — Sat, 17 Sep 2022 20:27:37 GMT

Just starting to look at Deneb and I have only been working with Power BI for a couple months and I use Field Parameters heavily I just did a small test and for the price of a couple extra measures you can indeed use field parameters with a deneb chart -- for a simple bar chart at least.

I did the following
Imported some fake data

Created the field Parametrs with an extra column named MeasureID

Used enter data to create this table Available Facts

Created the relationship

I allowed the Field Parameters slicer to be created but the Available Facts slicer can be used as well (it may be redundant)

i then used the simple bar chart template as follows

and as seen here changing the slicer does change the values in the chart

Far from a final polished solution but I would think by adding a few more measures to calculate the axis lables and title it would be a good start.

I thought i would share this.. I think this approach could possibly be generalized a bit?

Awesome tool, keep up the good work.

Re: Field Parameters in Deneb Visuals

rdavi10471a2 — Sat, 17 Sep 2022 20:29:36 GMT

I forgot to include the magic measure with more than 2 a switch statement would be better but for a simple test it works. Same logic could be used for the other axis.

SelectedFact = if(SELECTEDVALUE(AvailableFacts[MeasureId])=0,[SalesFake],[GPFake])

Re: Field Parameters in Deneb Visuals

dm-p — Sat, 17 Sep 2022 20:33:27 GMT

I've only managed with doing a coalesce of 'known' fields into a single field within the spec and did a brief twritter thread about it here when field parameters went into preview. One of the cool things about a visual like Deneb is that I get taught things too, so yes, I would love to know how you're managing it, and TIA 🙂

Cheers,

Daniel

Re: Field Parameters in Deneb Visuals

rdavi10471a2 — Sat, 17 Sep 2022 20:39:22 GMT

Just read that as well.. Looks like we did it the same way kind of thinking I just made power BI tell me what the actual selected measure was like your or in the Json i guess

Re: Field Parameters in Deneb Visuals

dm-p — Sat, 17 Sep 2022 20:40:01 GMT

Ah, this is similar to doing it with expressions inside the specification, so will work fine, as long as you don't mind setting up a measure to do so 👍

We'll do something like this automatically to the dataset internally when feature support is added. As per my other reply, we don't currently have anything useful in the visual metadata that tells us you're using a field parameter (or what its name is), so we'll likely create special roles (buckets) for you to add them to which will handle the conversion, unless MS can add some more metadata (which I have asked for, but have no idea if we'll get it).

Cheers,

Daniel

Re: Field Parameters in Deneb Visuals

alexjohnlittle — Wed, 15 Feb 2023 09:24:42 GMT

Did you ever try this with the 'other axis'? I'm trying to get it working for a category axis but this method doesn't work when creating the SelectedFact measure?

Re: Field Parameters in Deneb Visuals

Anonymous — Sun, 09 Apr 2023 04:45:25 GMT

Pls check https://github.com/deneb-viz/deneb/issues/238#issuecomment-1501033734 for the workarounds for Field Parameters in Deneb and SELECTEDVALUE()

Re: Field Parameters in Deneb Visuals

QC — Wed, 04 Dec 2024 16:22:13 GMT

This is hands-down the best tool of PBI!

Re: Field Parameters in Deneb Visuals

dm-p — Wed, 18 Dec 2024 21:57:11 GMT

Thanks very much! I'm glad you like it!