Help for selector JSON

[rdegr]

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}"

[hairstyledare55]

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!

[irisp]

First please format and validate your JSON data using 

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

[rdegr]

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?