Forum Discussion

shuiting's avatar
shuiting
Frequent Visitor
7 years ago
Solved

Line Chart question

Fairly new to Power BI and I am having an issue that I can't seem to resolve. I don't know if I'm asking this in the right way, but I have a line chart with two lines of data on it. X-axis is made up...
Need Help
  • shuiting's avatar
    shuiting
    7 years ago

    After a lot of trial and error, I figured out the solution. 

     

    Measure = IF(

       CALCULATE(

          COUNTA(table.column,table.column IN { "value A" })>0

     ||

       CALCULATE(

          COUNTA(table.column),table.column IN { "value B" })>0,

       COUNTA('YTD (2)'[Call/Email])+0,

       COUNTA('YTD (2)'[Call/Email])

    )

     

    you can copy and paste the CALCULATE function along with addition || operators to account for more values. Side note, || is equal to OR.

     

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi shuiting,

 

You could create a relationship between fact data table and a date dimention table based on [dates] field. Add [dates] from date dimention table onto X-axis of line chart, and set its type to "continuous".

 

If you still have any question, please post sample data. How to Get Your Question Answered Quickly

 

Regards,

Yuliana Gu

shuiting's avatar
shuiting
Frequent Visitor
7 years ago

v-yulgu-msft,

 

Thanks for the reply!

 

When I try to set the x-axis to continuous it just goes right back to categorical. The data is from a csv file and essentially it looks like this:

 

DateActivity Type
9/7/2018Email
9/7/2018Email
9/7/2018Connect
9/7/2018Connect
9/7/2018No Connect
9/7/2018No Connect
9/8/2018Email
9/9/2018Connect
9/10/2018No Connect
9/12/2018Connect
9/12/2018Email
9/12/2018No Connect

 

When I go to plot the count of each activity type on the y-axis and the date on the x-axis I end up with broken lines. For example, on 9/7/2018 there are 2 connects and on 9/9/2018 there is one connect. I want to count the number of activities for each day where there is at least one type of activity. So, 9/7/2018 should show as 2 Email, 2 Connect, and 2 No Connect; 9/8/2018 should show as 1 Email, 0 Connect, and 0 No Connect; 9/9/2018 should show as 0 Email, 1 Connect, 0 No Connect; 9/10/2018 should show as 0 Email, 0 Connect, and 1 No Connect; 9/11/2018 should not show up at all since there were no activities; 9/12/2018 should show as 1 Email, 1 Connect, and 1 No Connect.

 

I can add +0 to the end of the count function, but then that makes the days where there was no activity show up on the chart and I don't want the days with 0 total activities to show up on the chart.