Create Bar Chart based on Measures when sourcing data from a Power BI Dataset.

[Bhoga]

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.End Result

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

Data from PBI Dataset and ExcelPower BI Report

[v-alq-msft · Accepted 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.

[Bhoga]

@v-alq-msftThank you very much. Will do as suggested.

Cheers