Forum Discussion
Helper IPlotting 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:
7 Replies
manvishah17Solution Supplier
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:
DineshYadlHi Vishruti
Line chart supports only measures in Y-axis .
In addition, you can convert time format to numeric value.
Thanks
VishrutiHi,
Converting dates into numerical values is causing issue with sorting dates from earliest to latest
- DineshYadl
- v-menakakota
Community Support
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.
- v-menakakota
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
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