Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ricardomrferraz
New Member

Omission of lines on Power BI Report Builder

Hi

I have this lines on my dataset on Power BI Query and it's connected to Report Builder:Evidência 537 3.png

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:

Evidência 537 4.png

Thank you!

 

1 ACCEPTED SOLUTION
AmiraBedh
Resident Rockstar
Resident Rockstar

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.

 


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

View solution in original post

1 REPLY 1
AmiraBedh
Resident Rockstar
Resident Rockstar

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.

 


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors