Forum Discussion
Category missing
Hello,
The problem has been found.
It's because the mapping that I have made was incorrect!
Thank you all for your help, I appreciate it and sorry for the late response!
Hi, Anonymous
Please correct me if I wrongly understood your question.
I am not sure how your model looks like, but I assume and I think your legend is from DIM table, and your data is from Fact Table.
If Dim table does not contain all the information that exists in the Fact Table, then it looks like your picture.
- Instead of draging a column from DIM table, try to drag a column from FACT table.
Or,
- to make it a more proper model, fix the DIM table to contain all information.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/
You've understood the question correctly and thank you very much for your answer.
The only problem is that the information is not contained in the FactTable (or partly). I have 2 tables:
- DIM: which contains axis information with subaxis
- FACT: which contains subaxis information
I have linked the 2 tables by creating a bridge between the 2 of them which I called "Sub-Axis_Transfer". It worked before but now.. it does not anymore..
All the information is correct, I have checked. Everything works but 1 category and I do not understand why
Hi,
Thank you for your feedback.
If it is OK with you, please share your sample pbix file, then I can try to look into it to come up with more relevant suggestions.
thanks.