Forum Discussion

Bhoga's avatar
Bhoga
Frequent Visitor
5 years ago
Solved

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

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 t...
Interesting Links
Need Help
Tips and Tricks
  • v-alq-msft's avatar
    v-alq-msft
    5 years ago

    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.

v-alq-msft's avatar
v-alq-msft
Community Support
5 years ago

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's avatar
Bhoga
Frequent Visitor
5 years ago

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

Cheers