Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a table EMPLOYEE that has 3 columns, ID, NAME and SALARY.
In Database I inserted 4 records as shown below.
ID NAME SALARY
--------------------------------------
101 Employee 2000
102 eMployee 3000
103 EMPLOYEE 4000
104 employee 5000
When I create a report in powerbi desktop to show NAME and SALARY, it shows the NAME as "Employee" for all 4 rows. I want it to show as per Database. How to fix this issue?
Thanks
Solved! Go to Solution.
Infortunately, Power Bi and DAX are case insensitive.
you could use workaround from here https://blog.crossjoin.co.uk/2019/10/06/power-bi-and-case-sensitivity/
I think Chris Webb's BI Blog: Power BI And Case Sensitivity Chris Webb's BI Blog (crossjoin.co.uk) mentions that Power Query is case sensitive whereas DAX is not. So, for example, a table in Power Query will look like this:
However, within DAX, it looks like this:
From which you can see that DAX has ignored the change in case in rows 2 and 5.
Check the data in the import view. Is it in the same case as the database.
Using the ID should resolve your issues. Can you share the output you are seeing now.
Maybe it's coz of the summarization level.
Infortunately, Power Bi and DAX are case insensitive.
you could use workaround from here https://blog.crossjoin.co.uk/2019/10/06/power-bi-and-case-sensitivity/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |