Power BI Report Builder - Dynamic Parameter data type error text to int filter data.

[SmitShah_16]

Hello,

I have one requirement that I have One parameter as Start Month and Another Parameter as End Month in format as "MMM - YYYY" in text.
So, When I select Start month as ""Apr - 2024" then end month will be automatically greater than equal to april month.
So, that i have achieved but when the table filter the data it filter only selected month only like if i select start month = Apr 2024 and end month = June 2024. So, i am able to see only data from April -2024 and June -2024. It not showing May 2024. It is due to text value of parameter.
So, my requirement is that i need to show value as Apr - 2024 but i need filter the table in tablix as month number = 4.
How to achieve this?
Please someone help me here.

[Anonymous · Accepted solution]

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

[Anonymous · Accepted solution]

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

[bradsy · Accepted solution]

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.