Forum Discussion

Impromptu's avatar
Impromptu
Regular Visitor
1 year ago
Solved

Dont see First, Last, Count (Distinct), Count etc... on Columns dropdown

Hi,   Can't figure out why I can't see the First, Last, Count (Distinct), Count etc... when I go to Visulaizations/Columns/Country dropdown? I know that for Measures you dont see these options but...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Impromptu ,

    Agree with Irwan .
    After testing, I can basically rule out the possibility that there is a problem with the version 2.138.1203.0 64-bit (November 2024) of Power BI Desktop. At the same time, I also checked the settings of the pbix, and they are all correct. I copied the data of the pbix and used it to recreate a new pbix, and it was also normal. 


    I personally feel that there is something wrong with this pbix. I suggest that you try to contact the author of this pbix and ask him if he has performed some operations or settings that may cause this problem. 
    It is also possible that this pbix was created a long time ago and used a very old version of Power BI Desktop, which is incompatible with the latest or most recent version of Power BI Desktop. However, I have no idea what version the pbix was created with, so I have no way to verify it.


    My suggestion is that you can copy the data and then use it to recreate a pbix yourself for your testing.

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

Irwan's avatar
Irwan
Icon for Super User rankSuper User
1 year ago

hello Impromptu 

 

have you tried in new pbix?

i can see First, Last, Count (Distinct), and Count.

still data category is still uncategorized, and text format.

 

Thank you.

Impromptu's avatar
Impromptu
Regular Visitor
1 year ago

Thanks Anonymous  and Irwan ,

 

thanks for getting back.  I tried to copy the data to new pbix, but I don't have sql server so can't test as its asking for credentials.  I will take your word that you can see First, Last, Count etc...   Just wanted to make sure that I wasn't the only one not seeing these options.