Forum Discussion
Helper IIUnable to Categorize Visuals with Gridlines and Channel
I am trying emulate the following Power BI visual
In my visual, (on page 1) I'm trying to get the Months and categorize shown in X Axis. I would only like to get the vertical gridlines.
However, I'm unable to achieve the same visual using the model called 'my channel over time'
The best I can get with my visual is as follows:
Any thoughts on where I might be going wrong?
The pbix can be found
here
https://drive.google.com/file/d/1BteR382r17wp9OsrPDmHtwKGzBmtf4M6/view?usp=sharing
Hi caplogic ,
I know what you mean but it seems that there is no relationship between them. If you have relationships, you can create a measure and it will give you what you want.
I create two tables as you mentioned. Also they have relationships.
Then I create a calculated column.
Column = 'T1'[Month] & " "& RELATED(T2[Column1])Finally it gives me the things you want.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi caplogic ,
I know what you mean but it seems that there is no relationship between them. If you have relationships, you can create a measure and it will give you what you want.
I create two tables as you mentioned. Also they have relationships.
Then I create a calculated column.
Column = 'T1'[Month] & " "& RELATED(T2[Column1])Finally it gives me the things you want.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Yilong
Thanks for getting in touch.
So, is that how it was achieved in the original Executive dashboard?
