Forum Discussion

RafaelRSantos_'s avatar
RafaelRSantos_
Frequent Visitor
4 years ago
Solved

Problem to show LOOKUPVALUE

Hi guys, i'm facing a problem to show my LOOKUPVALUE in Matrix Visualization. I have an account number, eg: 1, 1.1, 1.1.1, 1.1.2 I used PATH function        Caminho = PATH('Contabil DimContaCo...
Need Help
v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

Hi RafaelRSantos_ 

Thanks for your reply.

>> I have some data showing seventh level, but some data exists in 5th level or 4th or 6th, etc, and when i filter to not show blank values the result is not what i expected.

So the problem you encountered is that the data of the seventh level went to other levels, and when you did not select blank in the filter, the table was empty. Actually it should show some non-null values, right?

 

Besides, the file you attached has been deleted. And I'm afraid we need to check your sample file (.pbix) instead of .csv file. Thanks.

 

 

Best Regards,

Community Support Team _Tang

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

RafaelRSantos_'s avatar
RafaelRSantos_
Frequent Visitor
4 years ago

Hi v-xiaotang , sorry for file expired, follows the new link again.

Arquivo 

I can't share the pbi, because sensitive data.

I think my problem is related with this link -> Parent Child Hierarchies