Stacked bar legend from presence in related table

[MarkPalmberg]

Hi.

Here's my model:

I'd like to create a stacked bar chart that displays sum of REVENUERECOGNITIONAMOUNT by FISCALYEAR with a legend for "GRAD." GRAD indicates that the CONSTITUENTDIMID from RECOGNITION is in the FACT_DEGREEAREA table.

The bar graph would display, for example, the total sum of REVENUERECOGNITIONAMOUNT by FISCALYEAR for the filtered COLLEGE value from RECOGNITION, colored by IN DEGREEAREA selection.

Thanks for any time you can spare for this question!

[Anonymous]

Hi @MarkPalmberg 

Appropriate measures and visuals sometimes give better results . So has your problem been solved ? If it has been solved, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MarkPalmberg]

No, @Anonymous , I wouldn't say this has been solved. Failing learning about a means of achieving the visual in my original request, it would be useful at least to know that it *can't* be achieved using Power BI.

[vanessafvg]

are you able to share some data?

[MarkPalmberg]

I suppose, @vanessafvg , I could just default to a different visual and simply use measures here, without any "fancier" graphs. The stacked bar would be nice to have but isn't a must-have. Again, I appreciate your time.

[MarkPalmberg]

Does this work for you, @vanessafvg ? Thanks for taking a look.