Plotting Date column on Y axis for Line Chart

[Vishruti]

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?

[v-menakakota]

Hi @Vishruti ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[DineshYadl]

Hi @Vishruti 

Line chart supports only measures in Y-axis . 

In addition, you can convert time format to numeric value.

Thanks

[Vishruti]

Hi,

Converting dates into numerical values is causing issue with sorting dates from earliest to latest

[DineshYadl]

Hi @Vishruti 

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

Thanks

[manvishah17]

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.