Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Continuous line bar chart

Hi, Hope you are fine during this Corona time.   I was working on a Power BI report and I came across a problem with my bar chart. I have a bar chart with some data about revenues and their forec...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi Anonymous 

For your case, you could use these two ways to get it:

1. add "+0" in the formula of the measure which is in Values of visual.

Measure = CALCULATE(SUM('Table'[bike sales])) + 0

 

2. adjust the formula as below:

Measure 2 = IF(ISBLANK(CALCULATE(SUM('Table'[bike sales])) ), 0.01, CALCULATE(SUM('Table'[bike sales])))
 
Regards,
Lin
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Lin,

 

I don't think this will help because there are no blanks. The rows are missing in the table. So there is no row zero can be added or a row that can be changed to 0,01.

 

Thanks for the answer though

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    6 years ago

    hi  Anonymous 

    If so, just create a dim date table and create a relationship with fact table, now use the same way as above.

    By the way, use date field from dim date table in a visual.

     

    If you still have the problem, please share your sample pbix file for us have  a test.

     

    Regards,

    Lin