Help with data hierarchy and visualization

[joselopez]

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).

So it's calculated

and here's the expected object

How could I address this problem?

[v-jayw-msft]

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,

Jay

[joselopez]

up