Forum Discussion
2 values in axis
Hi IF ,
Try this:
1. Create another table.
PTime / KTime = GENERATESERIES(1,7,1)
2. Create relationship.
3. Create measures.
PPrice Measure = CALCULATE(SUM('Table'[Price]),USERELATIONSHIP('PTime / KTime'[Value],'Table'[PTIme]))KPrice Measure = CALCULATE(SUM('Table'[KPrice]),USERELATIONSHIP('PTime / KTime'[Value],'Table'[KTime]))
4. Create a Clustered column chart visual.
Best regards
Icey
If this post helps,then consider Accepting it as the solution to help other members find it faster.
Hi Icey,
It works very well. Thanks a lot. However, now I have an issue. Actually, I am also using a matrix to show the count of PTime and KTime under the graph. I used unpivot option to do that. When I did unpivot, the table worked but I had a problem with graph. Therefore, I only posted the graph problem. After this method, I can not use unpivot option anymore and now I have a problem with the matrix. The matrix shows:
| COUNT | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| Ptime | 2 | 2 | 1 | 2 | 1 | 2 | 1 |
| Ktime | 1 | 1 | 3 | 0 | 1 | 1 | 3 |
I also made a table under the matrix and drag drop the Table[Category] column. If I select, 3 (Ktime:3 and value 3) it shows the values for d,e,f
| d |
| e |
| f |
You already helped a lot, but this graph should work with the matrix to see the category values. Will you be able to help me this part so that graph and table works together?
All the best