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 currently have two tables
EngineerCalendar
Visits
Joining the two tables using Cross filter Selection - Single
Not eveything will exist in the Visits Table, so when I created a Table with the following values
Engineer ID (Table: EngineerCalendar)
First Name (Table: EngineerCalendar)
Call No (Table: Visits)
I get to see the values I want to see
But if change the Values around swapping the First Name and Call No, I see the below which is not correct, as I should be seeing the First Name?
Does anyone know if this is a Bug in Power BI?
I have set the following on each Value Show items with no data
I basically need certains Values to be in a specific order.
Thanks
Solved! Go to Solution.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Thanks @AllisonKennedy so I need to make sure all the fields in the Table that relate to Visits need to appear first and fields from EngineerCalendar to appear after them
Have you set them all to Don't summarize as well? Otherwise your name might be trying to do a 'First' instead, giving you the error?
Also, because of the cross filter direction, if Andrew has no Call value, then you won't see his name in the Name when it is placed after Call.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Thanks for your reply.
Yes all the fields are set to Don't summarize.
Not sure what you mean when you have said:
"Also, because of the cross filter direction, if Andrew has no Call value, then you won't see his name in the Name when it is placed after Call. "
Yes for that particular day which I have a filter on Dates from the EngineerCalendar
EngYear = 2020
EngMonth = July
EngDay = 17
Andrew did not make any calls for that day but I still want to show the end users that row on the table,
I just find it strange that based on the position of the Values it shows a value but rearrage them it does not show the value.
Thanks
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Thanks @AllisonKennedy so I need to make sure all the fields in the Table that relate to Visits need to appear first and fields from EngineerCalendar to appear after them
Anyone have an answer for this?
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |