Forum Discussion
How to plot a column chart with fixed x and dynamic y axies
Hi PBI gurus,
I am using PBI to plot a column chart, like the one shown below:
I want to use all state names of the US as x-axis, and I use "New parameter" -> "Fields" to create a slicer to contain the field names I want to plot as y-axis, so that I can select to plot the data from either field vs. States.
However, when I make "X-axis" as "State", and "Y-axis" as the parameter fields I created, the column chart shows nothing, shown below:
But when I change column chart to a table, it displays correct values:
Please let me know how I can plot column chart as expected. Thanks a lot!
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/1447523Hi 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!
8 Replies
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/1447523
Thank you! Please see my new reply.
