Forum Discussion
How to plot a column chart with fixed x and dynamic y axies
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
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
Column chart visual expects to have numeric data type column/measure on the y-axis. Please check whether all fields used in the field parameter have been set to numeric data types, like whole number, decimal number, fixed decimal number...
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Thank you!
I made all the fields correct type.
Here is how I defiend the dynamic parameters in the "Baseline COM Columns" slicer. The items are actually in text type, not in number.
Now my question is, how to link my selected item in the "Baseline COM Columns" slicer to the real data column in a data table?
The data table is like this:
- Ritaf1983
Super User
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/1447523Thank you as well!
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!Thank you so much for the help!
I've solved this problem.
