Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Granularity issue

have three tables geography, sector and sales:       when I test the results:     Expected results: how to correct it?         I put an example of pbix file https://driv...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Based on your description, I did a test. Maybe you have set a filter on "IDSALES" column like "<=200".

    If you want to display this value on Power BI Desktop, You could just drag the field of "IDSALES" to the filter on table visual as follows.

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

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

     

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

Based on your description, I did a test. Maybe you have set a filter on "IDSALES" column like "<=200".

If you want to display this value on Power BI Desktop, You could just drag the field of "IDSALES" to the filter on table visual as follows.

Hope that's what you were looking for.

Best Regards,

Yuna

 

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