Issue in Data Modelling

[SwapnilMahajan1]

Hello everyone,

I'm trying to create a clustered bar chart and I've uplaoded 3 excel files.

Below is my data model

And below is the column chart I created for sample.

As per the raw data, there is no "blank" in category field of site information table. There are some "blank" values in Meter reference of Dataset table. Maybe because there is bi-directional field between them, it is creating issue? I tried setting the single directional flow from dataset to consumption but it is not making any improvement?
Please help.

[Anonymous]

Hi @SwapnilMahajan1 ,

if your relationship tables contains records who can't correct mapping to related table, it will shows value as 'blank' option in slicer.(blank option means the missing records)

For example, the blank value in the stacked column chart is actually the value of the ID "C".

Best Regards,

Stephen Tao

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