Forum Discussion
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?
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.
- Create new column:
Hi Vishruti
Line chart supports only measures in Y-axis .
In addition, you can convert time format to numeric value.
Thanks
Hi,
Converting dates into numerical values is causing issue with sorting dates from earliest to latest