Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have below tables connected with each other
I want to show, number of W Queries and Avg Time W queries column for each employee.
number of W queries & Avg time W queries are coming accurately. but when I move date slicer it doesn't update Av time W queries column. It only updates No of W queries.
Date slicer is connected with Queries table Date column.
How to get this working?
Appreciate any help with this.
Solved! Go to Solution.
Hi @tatees ,
You can create a measure instead of a calculated column.
This is my model relationship.
Use the [Date] of the date table as the value of the slicer. This measure changes when the slicer is slid.
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. Thank you.
Refer to:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @tatees ,
You can create a measure instead of a calculated column.
This is my model relationship.
Use the [Date] of the date table as the value of the slicer. This measure changes when the slicer is slid.
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. Thank you.
Refer to:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tatees,
Can you please share how you're calculating the two columns?
tatees,
I'm guessing the Date slicer on the page is using the Date field from the Queries table? There's no relationship between your Date Table and Queries, but it's the measure using the Queries table that updates when you change the date slicer.
In that case, you need a relationship between Date Table and Queries, and to use the Date field from the Date Table in your slicer.
If that's not the issue, can you please share a sample pbix file? (If you don't know how, please check the pinned thread in the forum.) It would make debugging your issue easier. 🙂
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
Thanks Wilson,
I tried creating relationship between date table and queries, but that doesn't work.
Due to client live data, I cannot share pbix file unfortunately.
Many thanks
tatees,
Understandable, but if you can't share a pbix, you're going to have to give feedback that's way more helpful than "doesn't work". 🙂
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
69 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |