Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Help with data hierarchy and visualization

I've had problems with a calculated column (This calculated column how many years that material has left to live).

While the calculation is correct... the problem is visualization (problems with Hierarchies, and when I annul hierarchies in options (time intelligence), you cannot place that value on the x-axis).

Problema 1.jpg

So it's calculated

probelma 2.jpg

and here's the expected object

valor esperado.jpg

How could I address this problem?

Community Support
Community Support

Hi @joselopez ,


Please show more information. I saw there's error on the hierarchies in the first screenshot, can you share the details? It's better to share the pbix to us if you don't have any Confidential Information. Or you could share some sample data and the formula you used to create the calculated column.


Best Regards,


Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Frequent Visitor


Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors