Forum Discussion

Vishruti's avatar
Vishruti
Icon for Helper I rankHelper I
1 year ago
Solved

Plotting Date column on Y axis for Line Chart

Hello, My requirement is to plot date column on Y axis and 2 fields on X axis - Product Risk Category (Low, Medium, High) and Product Names.   How can I achieve this?
Show and Tell
  • manvishah17's avatar
    manvishah17
    1 year ago

    Hi Vishruti ,

    • Matrix Visual (Recommended for Hierarchy)

      • Date → Rows
      • Product Risk Category, Product Name → Columns
      • Any Measure → Values

    • Bar Chart (For Categorized Representation)

      • Date → Y-axis
      • Product Risk Category → X-axis (use Measure )
      • Product Name → Legend

    • Concatenated Column (If X-axis Needs Both Fields)

      • Create new column:
        DAX:
        ProductCategoryName = Product[Product Risk Category] & " - " & Product[Product Name]
      • Use this column on the X-axis instead of separate fields.



     

  • DineshYadl's avatar
    DineshYadl
    1 year ago

    Hi Vishruti 

     

    It is not possbile to represent Date field in Line chart.

     

    Thanks

v-menakakota's avatar
v-menakakota
Icon for Community Support rankCommunity Support
1 year ago

Hi Vishruti  ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

v-menakakota's avatar
v-menakakota
Icon for Community Support rankCommunity Support
1 year ago

Hi Vishruti  ,

I hope the provided information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you