Omission of lines on Power BI Report Builder

[ricardomrferraz]

Hi

I have this lines on my dataset on Power BI Query and it's connected to Report Builder:

The first column is also a parameter with multi-selection values. When I run the report, some lines disappear. I think it's because upper and lower cases, but I want to know if this happened to anyone and how to solve this. Here it is how it appears when I publish the report:

Thank you!

[AmiraBedh · Accepted solution]

The issue you are facing seems to be related to the case sensitivity of the parameter values in your dataset. When using multi-selection parameter values in Power BI, the case sensitivity can cause discrepancies in filtering the data, and it might lead to some lines disappearing from the report.

- Make sure that the parameter values in your dataset are consistent in terms of casing. For example, if you have "Sim" and "Nao" in the dataset, ensure that the parameter values are also written in the same way in the report.

- Confirm that the data type of the parameter column in the dataset is set correctly to text or string. This will ensure that the comparison is done without considering case sensitivity.

- Modify the Report Query: If your dataset contains mixed casing, you can modify the Power BI query to convert the parameter values to a specific case (e.g., uppercase or lowercase) for consistent filtering. This can be achieved using the "Text.Upper" or "Text.Lower" functions in the Power Query Editor.

For example, you can apply the "Text.Upper" function to the first column (teste/teste2/Teste/Teste2) to convert all values to uppercase:

let
Source = // Your data source,
// Other steps in the query,
Transformed = Table.TransformColumns(Source,{{"Column1", Text.Upper, "UppercaseColumnName"}})
in
Transformed

If you choose to modify the report query to convert the parameter values to uppercase or lowercase, you should also update the parameter list in the report to match the same casing. This ensures that the parameter values selected in the report match the converted values in the dataset.