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.
Dear BI users,
Is there a way to check with date dimension is filtered on a chart : by day, by month, by year?
This is for switching DoD & MoM on a chart by X-axis date dimension.
My purpose and the findings of details so far listed below.
Purpose
Findings
Sincerely,
Lee, Hong Gwoo
Solved! Go to Solution.
OK, and I'm just confirming and talking this out in my head, what we need to do is either:
Honestly, I'm not sure any of those are possible but I'll spend some cycles noodling on it. The one that strikes me as the most plausible is #2 using something like PARALLELPERIOD maybe? Not thinking of an easy solution.
I am not understanding your issue. It looks like you have a single chart that has a Month and Day hierarchy that you can drill down and up or are you saying that you want to display both the MoM or DoD at the same time in a single visualization. I do not understand where the ISFILTERED comes into play. Can you please clarify?
First of all, thanks for your interest on the issue.
I illustrate the issue clearly below. Hope it helps your better understanding.
Purpose
Expected Solution
Sincerely,
Lee, Hong Gwoo
OK, I'm pretty sure I get it now, can you post your formulas for DoD and MoM?
Below is the formulars.
Thanks in advance for your kindness.
BR,
Lee
@extri13 - Something I just found that you might want to vote for (although it is already started):
OK, and I'm just confirming and talking this out in my head, what we need to do is either:
Honestly, I'm not sure any of those are possible but I'll spend some cycles noodling on it. The one that strikes me as the most plausible is #2 using something like PARALLELPERIOD maybe? Not thinking of an easy solution.
Thank you very much.
It seems like there is no right answer for my need based on the opinion of you who is one of the most professional user on this board I've seen so far.
I am really really impressed by your kindness and passion for BI from your answer.
Also, it is still a good answer that there is no solution.
Thanks again
Lee, Hong Gwoo
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |