Forum Discussion
Power BI Report Builder - Dynamic Parameter data type error text to int filter data.
Hi,
To filter your data based on month numbers while displaying the text format "MMM - YYYY," you can create an additional calculated column in your data source that converts the month text to a corresponding numeric value. Then, use this numeric column for your filtering logic. In your Power BI Report Builder, set the parameters to filter based on this numeric column while displaying the text values. This approach ensures accurate filtering across the selected date range.
Regards,
Chiranjeevi KudupudiFor cases like this, I usually will set the prameter value as a number and parameter label as readable text where the value and label are tied 1->1 mapping in my data. Something like DateMonth as integer and DateDisplayMonth as whatever I like to call it.
Hi,
To filter your data based on month numbers while displaying the text format "MMM - YYYY," you can create an additional calculated column in your data source that converts the month text to a corresponding numeric value. Then, use this numeric column for your filtering logic. In your Power BI Report Builder, set the parameters to filter based on this numeric column while displaying the text values. This approach ensures accurate filtering across the selected date range.
Regards,
Chiranjeevi Kudupudi
For cases like this, I usually will set the prameter value as a number and parameter label as readable text where the value and label are tied 1->1 mapping in my data. Something like DateMonth as integer and DateDisplayMonth as whatever I like to call it.