Date Fields - Don't want to default to Hierarchy

[psyang]

I have a custom visual that takes a datetime field. However, the visual requires the field to be entered as a straight date, not a date hierarchy.

I was hoping there would be something I could put in the capabilities.json file to:

1) Ensure the field entered is a datetime field

2) Ensure the datetime does not come in as a date hierarchy.

However, I don't see anything in requiredTypes or preferredTypes for datetime fields. Am I out of luck?

[v-viig · Accepted solution]

The first issue can be easily resolved in TypeScript code by checking type of column:

if (dataView.metadata.columns[dateColumnIndex].type.dateTime) {
    // TODO: Put some code here
}

The second issue with date hierarchy can be resolved by adding a condition into capabilities.json:

            "conditions": [
                {
                    "Time": {
                        "max": 1
                    }
                }
            ],

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[psyang]

Thanks for the quick response.

#1 isn't ideal, but maybe that's the best solution. It seems strange that we can restrict fields to numbers, strings, or booleans, but not dates. Hopefully this gets added to the available preferred/requiredTypes enumeration.

#2 works great!

Thanks again!