Forum Discussion

joselopez's avatar
joselopez
Frequent Visitor
5 years ago

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?

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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