Forum Discussion

marketwasher's avatar
marketwasher
New Member
6 years ago
Solved

Power BI - "Do not summarize" missing - Not showing actual data

Please help! I am looking to make a chart to show the actual data by month. But "Do not summarize" is not available. Please advise

I already converted all data to numbers.

 

 

Here is the chart I am looking for.

Need Help

5 Replies

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi marketwasher 

    you are using higher level of date hierarchy

    remove Quarter and Day from axis field then press on "Expand all down" button in visual, which looks like

     

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution

    • marketwasher's avatar
      marketwasher
      New Member
      6 years ago

      Thank you for the swift response. That fixes the date but the "count" is still showing

      Here is what I have so far. 

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi marketwasher ,

     

    Kindly share your sample data to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.