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 am trying to obtain similar solution as shown below in Table visualization. I know I can do with matrix visualization easily but I have other calculated measures I need to add to this so I am doing in Table visual. To be precise I am looking for current week and going forward. Can you please help me.
Thanks
Sush
Solved! Go to Solution.
To do that, you would need to create separate measures for each column like this
Week 1 = CALCULATE([Your Measure], Source[Week] = 1)
Week 2 = CALCULATE([Your Measure], Source[Week] = 2)
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi @Anonymous,
You can take a look at the following blog about pivot column to expand your value fields to columns if they meet to your requirement:
The New Pivot Column option in Power Query
Regards,
Xiaoxin Sheng
To do that, you would need to create separate measures for each column like this
Week 1 = CALCULATE([Your Measure], Source[Week] = 1)
Week 2 = CALCULATE([Your Measure], Source[Week] = 2)
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
This works. Thankyou! I was also looking for date for column name instead of week1, week 2 etc. like Aug 17 , Aug 24. Do you know how can i do it dynamic.
I don't think you can dynamically name your measure, but you could provide the Week Date in the result concatenated with the result (e.g., <Date expression> & " - " & CALCULATE(...), but that probably isn't what you are looking for.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
107 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
142 | |
105 | |
103 | |
85 | |
70 |