The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Good morning all,
I am trying to display a table of the Top 10 faults for a particular machine on a per week basis.
For some reason it displays a (seemingly) random number of faults and I am unsure why.
Here is a screenshot of the table as it is displayed right now.
This other table is from the exact same data and works correctly:
Any pointers as to why I'm seeing this behaviour would be great.
@icbd The filtering context of the two visuals are different. In visual 1, you filter in configstation.id=1, in visual 2, configstation.id=2. Could it be in Week 2022-07-17, there are only 2 items appearing because they are only two items meeting the condition configstation.id=1?
its hard to see without seeing what your model looks like. also place your countid column on the page, that might give you some insight.
Proud to be a Super User!
It is in the "Amount" column which has been renamed.
what does your data model look like?
Proud to be a Super User!
I simplified the model quite a bit, unfortunately everything is DirectQuery so I cannot upload a file.
Hope this helps you out in helping me.
The date table is marked as such. I added a column to it to get the starting day of the week in there (sundays). This is what I am using to sort by week.
So long as I don't use the TOP N filter, everything works as intended.
I think the issue could lie in the fact that you have a many to many to many relationship between date and your table but im not sure without access to some sample data, the issue would almost certainly be in your model in my opinion. are you placing the date from the date table? if you swap it for the date in your table does it make any difference?
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
92 | |
90 | |
72 | |
69 |
User | Count |
---|---|
232 | |
128 | |
117 | |
82 | |
82 |