Forum Discussion

o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
3 years ago

Couldn't load the data for this visual

Hi all

 

My page is not loading the measures, it gives the following error:

 

 

 

However, If I filter all the countries one by one manually in the slicer, the measures will load correctly:

 

 

 

Any idea how to solve this?

 

Thanks.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi o59393 ,

    According to the error message, it seems that there is some error in the measure 'Query1'[Max demand KO year 0]. This error message usually occurs when a DAX formula is expecting a single value but instead receives a table of multiple values. Could you please share some raw data and the formula of measure 'Query1'[Max demand KO year 0] with us? Later we can check it and give you suitable solution for you.

     

    In addition, you can refer the solution in the following threads to solve it.

    Solved: Error - A table of multiple values was supplied wh... - Microsoft Fabric Community

    Solved: Re: ERROR: A table of multiple values was supplied... - Microsoft Fabric Community

    Best Regards

    • o59393's avatar
      o59393
      Icon for Post Prodigy rankPost Prodigy

      Hi Anonymous  let me share the pbix, I will remove some sensitive data first.

       

      Thanks.

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi o59393 ,

        Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

        Otherwise, could you please share your sample pbix file for the further troubleshooting and giving you a solution? Thank you.

        Best Regards

    • o59393's avatar
      o59393
      Icon for Post Prodigy rankPost Prodigy

      Hi Ashish_Mathur  let me remove some sensitive data and i'll share it with you.

       

      Thanks.