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 want to display the data in the following way: -
1. Each day of the week gives me the summary for the week.
Let's take Monday. I have a measure and Time Hierarchy (Year, Months, Days). Now, is it possible to have the data only displayed for Jan 2, Jan 9, Jan 16, Jan 23 and so on without manually choosing the those days in the filter? I mean every time the data is refreshed in the cube I should be able to see only the data for every monday automatically updated. (Assume gateway is setup and working fine)
So if I open the report in march, it should have the data for every monday starting Jan 2 without me choosing those days in the filter.
Is it possible?
Solved! Go to Solution.
Hi @Anonymous,
There are 2 common approaches that you could try:
Weeks Rep = 'Fact'[DateColumn]- WEEKDAY('Fact'[DateColumn]-2)
please change this column format in Formatting tab of Modeling tab to what format you want
Hi @Anonymous,
There are 2 common approaches that you could try:
Weeks Rep = 'Fact'[DateColumn]- WEEKDAY('Fact'[DateColumn]-2)
please change this column format in Formatting tab of Modeling tab to what format you want
Can we do the same on Live Connection?
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 |
---|---|
112 | |
97 | |
83 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |