Forum Discussion
Make a graphic - Beginner
Hello !
I have in Excel file a field named Contract type who contain 3 contracts (as below): LTA, Mega-tender, STA.
When in PowerBI I select to put into a graphic only the value for LTA?
I want to make a graphic such as:
Thanks
Hey Anonymous ,
I'm not sure if I understand your requirements 100%
It seems that you want to use 4 categorical variables to visualize your data.
- destination country, this is used to create the stacked segments for a column
- supplier, this is used to provide the content for each axis
- owner company, this is used to facet the data vertically
- contract type, this is used to facet the horizontally
Unfortunately, this can not be achieved using the default visualizations, as the small multiple feature allows only one variable to facet your data. The picture below demonstrates this:
For this reason I recomend creating 3 visual, you can add the contract type to the visaul level filter and choose one contract type for each of the three visuals. Add the selected contract type to the title of the visual.
If you are using the Zebra BI custom visual you can achieve (as far as I understand your requirement) what your are looking for with a single visual, but you have to be aware, that the Zebra BI visual is a paid visual, that does not reveal all its capabilities in the free version.
Hopefully, this provides some ideas on how to tackle your challenge.
Regards,
Tom
1 Reply
- TomMartens
Super User
Hey Anonymous ,
I'm not sure if I understand your requirements 100%
It seems that you want to use 4 categorical variables to visualize your data.
- destination country, this is used to create the stacked segments for a column
- supplier, this is used to provide the content for each axis
- owner company, this is used to facet the data vertically
- contract type, this is used to facet the horizontally
Unfortunately, this can not be achieved using the default visualizations, as the small multiple feature allows only one variable to facet your data. The picture below demonstrates this:
For this reason I recomend creating 3 visual, you can add the contract type to the visaul level filter and choose one contract type for each of the three visuals. Add the selected contract type to the title of the visual.
If you are using the Zebra BI custom visual you can achieve (as far as I understand your requirement) what your are looking for with a single visual, but you have to be aware, that the Zebra BI visual is a paid visual, that does not reveal all its capabilities in the free version.
Hopefully, this provides some ideas on how to tackle your challenge.
Regards,
Tom