Forum Discussion

Bese's avatar
Bese
Helper I
2 years ago

Issue with bar chart and calculated values

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

Need Help

3 Replies

  • foodd's avatar
    foodd
    Community Champion
    2 years ago

    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-Forum/ba-p/963216

    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/1447523/highlight/true#M607150

    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!

  • AnkitaaMishra's avatar
    AnkitaaMishra
    Super User
    2 years ago

    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's avatar
      Bese
      Helper I
      2 years ago

      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.