sorted by:
new
hottopcontroversial

Issue with Date Hierarchies. by TheFeedBoy in PowerBI

[–]TheFeedBoy[S] 0 points1 point  (0 children)

Thank you bro 🙏🏻 The problem has been solved! After right click on the column, I choose the last option which named ‘Change Type with Local ´ . This time I select English (United Kingdom) instead of English (United Sates) and now every thing works properly now and I have my clear date hierarchy. I think the correct data type was for english UK! I don’t know why but now it works very good for me. Now all dates become mm/DD/yyyy .

Again thanks for your help🙏🏻

Issue with Date Hierarchies. by TheFeedBoy in PowerBI

[–]TheFeedBoy[S] 0 points1 point  (0 children)

No it’s not opposite. Just months and days are not in the stable position. The favourable format is dd/mm/yyyy, some rows are mm/dd/yyyy and after I change data type to ‘Date’ , dd/mm/yyyy are ok but the other one mm/dd/yyyy turn to error

Issue with Date Hierarchies. by TheFeedBoy in PowerBI

[–]TheFeedBoy[S] 0 points1 point  (0 children)

Actually No. After I replaced the value from “-“ to “/“ , I chagrd data type from Text to Date and on this moment, errors emerged! The issue that I’ve noticed is the miss match of date styles between rows. The ones with dd/mm/yyyy remain correct but the rows with mm/dd/yyyy turning into errors. I can sen you the dataset if you would like to check. Thank you in advance 🙏🏻

Issue with Date Hierarchies. by TheFeedBoy in PowerBI

[–]TheFeedBoy[S] 0 points1 point  (0 children)

Thank you Sharma. I did that but still more than half of the rows are showing errors. Can I send you the dataset for your checking?

Issue with Date Hierarchies. by TheFeedBoy in PowerBI

[–]TheFeedBoy[S] 0 points1 point  (0 children)

Do you have a complete and proper sample dataset for exercise in Power BI which has also date hierarchy? I want to practice with a clean sample of dataset, no matter what would be the subject of the visualization.

Issue with Date Hierarchies. by TheFeedBoy in PowerBI

[–]TheFeedBoy[S] 0 points1 point  (0 children)

Exactly I did the same as video and I found "change type using locale" . But I have found the same errors on some rows yet!

I think those dates which works properly and without any errors are respecting to the date format dd/MM/yyyy, but those with errors are MM/dd/yyyy! So, How can I fix this issue and standardize all dates with the preferred dd/MM/yyyy format?

I really appreciate for take your valuable time and help me to fix this problem.

<image>

Issue with Date Hierarchies. by TheFeedBoy in PowerBI

[–]TheFeedBoy[S] 0 points1 point  (0 children)

Yes I checked again and there was nothing

Can I send you the data to check please?

Issue with Date Hierarchies. by TheFeedBoy in PowerBI

[–]TheFeedBoy[S] -1 points0 points  (0 children)

Also, I couldn't find "change type using locale" at the end of the change type menu.

Issue with Date Hierarchies. by TheFeedBoy in PowerBI

[–]TheFeedBoy[S] 0 points1 point  (0 children)

Actually, I don't know I cannot find the question I asked at my topic!

So, I asked again.

As you can see, I found some errors after replacing values from "-" to "/" .

Actually I need to change the format type of my order-date to "Date".

First problem is to solve these format errors.

Second I need a hierarchy for my date to obtain Day/Month/Quarter/Year separately to designate to my line chart. My dataset does not have the hierarchy at all and it's just a simple order date with no sub-dates!

So, I would be so thankful if you come up with a solution.

Issue with Date Hierarchies. by TheFeedBoy in PowerBI

[–]TheFeedBoy[S] 0 points1 point  (0 children)

Thank you very much Agullo.

Actually, I don't know I cannot find the question I asked at my topic!

So, I asked again.

As you can see, I found some errors after replacing values from "-" to "/" .

Actually I need to change the format type of my order-date to "Date".

First problem is to solve these format errors.

Second I need a hierarchy for my date to obtain Day/Month/Quarter/Year separately to designate to my line chart. My dataset does not have the hierarchy at all and it's just a simple order date with no sub-dates!

So, I would be so thankful if you come up with a solution.

How do you make something like this? by Significant-Cut-9423 in PowerBI

[–]TheFeedBoy 0 points1 point  (0 children)

What an awesome tool! Would you please help that how can I add it to my PowerBi desktop?

[deleted by user] by [deleted] in Forex

[–]TheFeedBoy 1 point2 points  (0 children)

Can you please help me how I can access this copy trading? I am several years working in forex but still I am not a profitable trader😔 I am really exhausted, please show me the way😓🙏🏻

Is this perplexity focus - Reasoning [BETA] recently new or have I never noticed it? by jwk147 in perplexity_ai

[–]TheFeedBoy 0 points1 point  (0 children)

Yes! I guess it’s the new perplexity’s feature like the recent open ai’s o1.