topic Re: Help for selector JSON in Developer

Help for selector JSON

rdegr — Wed, 10 Oct 2018 15:27:01 GMT

What is represented by the value of the 't' attribute below? I need to build similar selectors, that doesn't seem to correspond to anything in the metadata for the related category. I'm trying to build a filter that lets you select different fields, then a value from the field, but createSelectionId() is creating selectors that filter across multiple fields which is not desired.

"{"selector":"{\"data\":[\"{\\\"comp\\\":{\\\"k\\\":0,\\\"l\\\":{\\\"col\\\":{\\\"s\\\":{\\\"e\\\":\\\"qtEmergencyRecords\\\"},\\\"r\\\":\\\"Year\\\"}},\\\"r\\\":{\\\"const\\\":{\\\"t\\\":4,\\\"v\\\":2017}}}}\"]}","highlight":false}"

Re: Help for selector JSON

irisp — Fri, 12 Oct 2018 02:32:11 GMT

First please format and validate your JSON data using

https://jsonformatter.org/json-parser or https://codebeautify.org/jsonvalidator.

Re: Help for selector JSON

rdegr — Fri, 12 Oct 2018 12:07:54 GMT

Irisp, that's not "my" JSON, its a selector query string I captured while debugging selection activities. It's string data from a larger JSON object, thus the escapes. Can you answer my question?

Re: Help for selector JSON

hairstyledare55 — Sat, 17 May 2025 20:41:33 GMT

Thanks for clarifying that it's a captured selector string from a Power BI visual interaction.

The t attribute inside the JSON ("t":4) typically represents the data type of the constant value. In Power BI's internal selector system:

t:1 is usually text/string
t:2 is boolean
t:3 is decimal/float
t:4 is integer

So "t":4, "v":2017 means you're filtering the Year column by the integer value 2017.

If you want to dive deeper into how selectors and JSON structures work for filtering and visualization, I recommend checking out some detailed tutorials and tools at @https://artdrivethru.com/json-formatter . They have useful resources on JSON formatting and selector logic that might help with your project.

For your use case, make sure to construct the createSelectionId() call carefully to target just one field at a time to avoid unwanted cross-field filtering.

Hope this helps!