Data reporting

[JAmbrose69]

So new to Power Bi and the community. please let me know if this is the correct forumn.

I have an ask to put together a chart that would depict a business unit broken out by number of Crit/high/med vulnerabilities per month across a 6 month time frame. These would be additionally broke out by aged <30/30-60/>90. I am able to get the business unit with aged <30/30-60/>90 but then I am having trouble showing it for Crit/high/med vulnerabilities. How would I beable to divide the column further into showing these?

[parry2k]

@JAmbrose69 you cannot have multiple columns on the legend when hack could be to add a column that concatenates both vulnerability & age and use that on the legend.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[amitchandak]

@JAmbrose69 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[JAmbrose69]

https://pfgsales-my.sharepoint.com/:f:/r/personal/james_ambrose_pfgc_com/Documents/test%20BI?csf=1&w... 

[JAmbrose69]

I can upload a PBIX and the excel with it. Not sure how. 

[v-lili6-msft · Accepted solution]

hi @JAmbrose69 

it could achieve that have multiple columns on the legend, so there are two workaround for you refer to:

1. Drag vulnerabilities column into Axis too.

2. As parry2k said, create a new column that combines "aged" and "vulnerabilities "  column into one column.

New Legend = 'Table'[aged] &"-"&'Table'[vulnerabilities]

then drag this new column into Legend

By the way, to upload a PBIX or the excel file, you can upload it to OneDrive for business and post the link here. Do mask sensitive data before uploading. 

Regards,

Lin