Forum Discussion

paopau86's avatar
paopau86
New Member
7 years ago
Solved

Issues with bar & line chart

Hi - I created a stacked bar/line chart to show two sets of data, the first column (bars) show dates when someone contacted me, and the second column (line) shows when an actual meeting was scheduled...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi paopau86

    1. Open Edit queries

    click on columns "contact" and "meeting", select "transform"->unpivot columns

    then i get the following table

    close &apply

    2.

    create a new table, enter the formula in the formula bar in"Home"->"new table"

    date = CALENDARAUTO()

    create a relationsip between this date table and my data table

    3. create two measures

    contacts = CALCULATE(DISTINCTCOUNT(Sheet5[company]),FILTER(Sheet5,Sheet5[Attribute]="contact"))

meeting = CALCULATE(DISTINCTCOUNT(Sheet5[company]),FILTER(Sheet5,Sheet5[Attribute]="meeting"))

     

    Best Regards

    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi paopau86

Based on my experience, it seems you didn't use the chart correctly.

please share a simple dataset as an example and tell me what you need to see from the visual, so that i can reproduce your scenario and help you create the correct visual.

 

Best Regards

Maggie

  • paopau86's avatar
    paopau86
    New Member
    7 years ago

    Thank you so much for the responses - I am new user of Power BI and I am trying to learn as I go (planning on taking a course soon), I appreciate your assistance. 

    Below is a sample of the information I want to show in a chart. Basically, I would like to show in a bar how many people I contacted every month (e.g. August would have two contacts and in september 1) and then in a line show how many meetings occurred on the given month (one meeting in August, and two in september).

     

    Thanks again!

    Paola

     

     

     

    • v-juanli-msft's avatar
      v-juanli-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      Hi paopau86

      1. Open Edit queries

      click on columns "contact" and "meeting", select "transform"->unpivot columns

      then i get the following table

      close &apply

      2.

      create a new table, enter the formula in the formula bar in"Home"->"new table"

      date = CALENDARAUTO()

      create a relationsip between this date table and my data table

      3. create two measures

      contacts = CALCULATE(DISTINCTCOUNT(Sheet5[company]),FILTER(Sheet5,Sheet5[Attribute]="contact"))

meeting = CALCULATE(DISTINCTCOUNT(Sheet5[company]),FILTER(Sheet5,Sheet5[Attribute]="meeting"))

       

      Best Regards

      Maggie

       

      Community Support Team _ Maggie Li
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.