Forum Discussion
How to plot a column chart with fixed x and dynamic y axies
- 2 years ago
Hi JTan
The parameters names as a text that's ok,
If all the referenced columns are whole/decimal number type and it still doesn't work ,
then maybe we are missing something in your description.Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 - Anonymous2 years ago
Hi JTan
Sorry, my previous reply was going in the wrong direction. I checked the official document, this was caused by the following limitation:
- You can't use implicit measures, so if you need an aggregated column as one of your fields, you need to create an explicit DAX measure for it. For more information, see implicit vs. explicit measures.
Due to above limitation, you need to create a measure for each field column. For example,
# Cost Savings = SUM('#BaseLine'[Cost Savings])# Energy Savings = SUM('#BaseLine'[Energy Savings])............Then use these measures in the field paramter.Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Hi JTan
The parameters names as a text that's ok,
If all the referenced columns are whole/decimal number type and it still doesn't work ,
then maybe we are missing something in your description.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Thank you as well!