Forum Discussion

Danny2020's avatar
Danny2020
Helper I
10 months ago
Solved

Report Builder - Issue with line chart average

Hello,   I have a database with quantities per part number, for multiple dates. Usign power query I created a second table grouping the part numbers, so they are listed with no duplicates. I creat...
Need Help
  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    10 months ago

    Hi  Danny2020 ,
    Thanks for reaching out to the Microsoft fabric community forum.

    Firstly to fix the error, In Report Builder and make sure the Name matches the DAX variable name exactly  for example, use @Part_Number instead of PartNumber. Then, in the Parameter Value field, link it to your report parameter by setting it to =Parameters!PartNumber.Value. This ensures that the DAX query recognizes and correctly applies the parameter value passed from the report.

    Additionally,  make sure the parameter data type matches the column type in your model. If 'Database'[Part Number] is a text field, the report parameter should also be defined as text, if it’s numeric, then the parameter type must be numeric as well. Mismatched data types can prevent the filter from applying correctly and cause the query to fail.


    I hope this information helps. Please do let us know if you have any further queries.
    Thank you

Danny2020's avatar
Danny2020
Helper I
10 months ago

v-nmadadi-msft , thank you so much for your solution. Changing to "Part_Number" from the database worked. However I'm still getting error message that Part_Number is not declared, but it lets me run the charts this time. Report Builder has a lot of issues, decades of old interface. It should be integrated within Power BI desktop.