Issue with bar chart and calculated values

[Bese]

Hi together,

currently I´m facing some issues by creating a PowerBi Dashboard with calculated values in a bar chart.

If I put the calculated values into a bar chart it is not possible to have seperated bars and they stick together. I have tried to created a Table which I can use to create the bar chart like I need it but here it is not possible to filter the values as they are static.

Please find my example file to better understand my problem.

Microsoft Forum

Thanks in advance,

Fabian

[AnkitaaMishra]

Hi @Bese , 
If my understanding is clear and your expected output looks like below snapshot then please follow below steps : 

Expected Output : 

Steps to perform : 

• go to format your visual pane
• Click on Columns
• Under layout, increase the space between series as shown below : 
  

if this resolves your issue, please accept this reply your solution.

Thanks,

Ankita

[Bese]

Dear Ankita,

thanks for your reply. This is how I use it in the current real report but I´m not happy with that solution, thats why I rised the question here. The problem with just adopting the space between series is that there is a lot of unused space in the graf as everything is just put in the middle and it is also not possible to have the labels under the bar.

I still hope there is a different solution for this problem.

[foodd]

Hello @Bese,  remember to adhere to the decorum of the Community Forum when asking a question.

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot). You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then share a file’s URL.

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.  Proud to be a Super User!