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,
Client requirement is to create a Bar Chart with a comparison between the forecast totals for the Project Identifier with an Approval Status as Development and Deliver as below. He is able to achieve this in Excel as per the 1st screenshot.
If 'Ready for Tender Date' is BEFORE 01st of Current Month, then the Approval Status is classified as 'Development' and if it is either 01st or AFTER 01st of Current Month, then the Approval Status is classified as 'Deliver'. Screenshot below for your reference.
Data is being sourced from a Certified Power BI Dataset, therefore, I don't have much options except to create DAX Measures and Data Modeling is of no use anyways!
I created a Measure as below to get a column into a table visual.
MPD Project Stage =
IF (
NOW () < MAX ( Project[Ready for Tender Date] ),
"Development",
"Delivery"
)
Client is able to achieve
Even tried and successfully split this column by using 2 Measures to get only Development and Delivery into 2 separate columns but couldn't use any of these in Columns Charts.
I've tried to use Q@A Visual just in case it picks up something but no use.
Someone mentioned SWITCH and SELECTEDVALUE will do the magic but not quite sure how to go about with it!
Has anyone come across this scenario and how did you get to a solution?
Any help in this regards is greatly appreciated.
Thanks, B
Solved! Go to Solution.
Hi, @Bhoga
It is unsupported to create calculated column for a Power BI dataset live connection data source. And you need to put a column instead of a measure in the 'Axis' of the bar chart. I'd like to suggest you create a calculated column in the Power BI dataset and then connect to it.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Bhoga
It is unsupported to create calculated column for a Power BI dataset live connection data source. And you need to put a column instead of a measure in the 'Axis' of the bar chart. I'd like to suggest you create a calculated column in the Power BI dataset and then connect to it.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |