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 All,
I'm having difficulty in display week automatically in power BI. The idea is the date for weekly will be get from data sources. For data example 11/05/2018 to 17/05/2018, 18/05/2018 to 24/05/2018. Before this I have to type and change manually when the date is coming. Is there possibility to make it automate by using formula. I'm new to power bi and just getting started to explore.
Hi @anis_keyna,
The Card visual can display only one value instead of multiple values.
In your scenario, would you please clarify "The idea is the date for weekly will be get from data sources. For data example 11/05/2018 to 17/05/2018, 18/05/2018 to 24/05/2018. "? Do you mean you want to display value "11/05/2018 to 17/05/2018" in the card visual?
Best Regards,
Qiuyun Yu
Yes I would like to display 11/05/2018 to 17/05/2018" in the card visual. The idea is to auto display when it reach the date. Meaning the date display will be change weekly based on the data sources. Is it possible?
Hi @anis_keyna,
Not sure the exact date you mean in this sentence "The idea is to auto display when it reach the date. " Assume it's the maximum date in the table, you can create a calculated column to return the maximum date below:
MaxDate= CALCULATE(MAX('Table'[Date]),ALL('Table'))
Then you can create a measure:
Measure = DATEADD('Table'[MaxDate],-7,DAY) & "to " & MAX('Table'[MaxDate])
If above doesn't meet your requirement, please use some sample data to show desired results.
Best Regards,
Qiuyun Yu
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |