field parameters and barchart

[Anonymous]

Hi all,

I am really new to Power BI and I have a task that I am struggling to complete the last two days. I have a table with some columns that contain only numeric data. I also have a column that contains the month in the format dd/mm/yyyy for better handling in the bi tool. What I want to do is to create a barchart that the user can select a column on the slicer with the month to be on the x-axis. I tried this with the field parameter and I created a table and a slicer that contains the 10 columns I would like to show on the barchart. I put this table as the y-axis. Then, from my original table, i select the month as my x-axis. The result is that no matter the column I select from the slicer I have a blank barchart. If I individualy try to create barchart with any of the columns everything works fine. I don't know what is the way to connect month to each and every column of the field parameter.

Any assistance on this task would be highly appreciated.

[Anonymous · Accepted solution]

I finally managed to solve this issue. The problem was that on field parameters, the columns are passed just as they are without the option to be aggregated. If we want the columns to be displayed aggregated and combined with other slicers like month etc. we need to create a Measure table that will contain all the aggregated values and then use THIS table on the field parameter and on th x axis the month as usual. I tried and it works perfect. But thanks for you comment @amitchandak anyway! 🙂 Cheers!

[amitchandak]

@Anonymous , check there is no visual level or page level filter. I tried Field parameter many times and did not face issue like that

Power BI- Create dynamic slicers using field parameters: https://youtu.be/H2ZxWaHAJZQ
https://medium.com/@amitchandak/power-bi-power-bi-create-dynamic-slicers-using-field-parameters-202587d4dedb