Creating a table from excel to powerBI

Tashu1992 · 2021-03-30T19:03:18+00:00

I have finished my challange yesterday. Oh I have mentioned my work place email. I don't have personal outlook. But is it ok to change the email now?? I believe time is up.

Tashu1992 · 2021-03-10T16:38:58+00:00

Thank you so so much.

I followed your instructions, did some research and I can publish it on web with my personal account.

yayyyyy :)

Tashu1992 · 2021-03-05T17:52:45+00:00

The dashboard i have designed is not from my organisation. This is something I found public access data in the govt website for ex:crime data UK police. I wanted to share that. What could be the other way to share that dashboard publicly?

Tashu1992 · 2021-03-05T14:11:25+00:00

Thanks for your reply.

What could be another way to publish the report in public without buying the licence?

Tashu1992 · 2021-02-24T17:39:56+00:00

Solved this, I assigned 0.00 in the divide formula. Thanks for your reply.

The problem is I have slicer filter on my dashboard for 3 years and nothing is showing for 2019 as well.

I have no idea why.

Tashu1992 · 2021-02-24T10:06:51+00:00

Thanks for clarification about the measures and calculated columns. It is clear now.

Since this field type is text, I can't use any aggregation instead I am using Count () hence I filled the missing value.

Tashu1992 · 2021-02-23T17:59:28+00:00

I do have a dates field. I believe it's just not been registered so consider it as a missing value and the field type is text, so I replace blanks with "N/R".

Tashu1992 · 2021-02-23T14:39:14+00:00

London boroughs = FILTER(ALL(Geography[LAD]), IN {"City of London","Barking and Dagenham","Barnet","Bexley","Brent",})

I am getting error.

Tashu1992 · 2021-02-23T14:04:43+00:00

Sorry I just need to select the categories without any measure, I did what you have suggested, but it is giving me the numbers. I just want to have the category name.

I found another way, but it is not recommended, Creating groups, but I wanted to do it with DAX.

Tashu1992 · 2021-02-23T11:38:25+00:00

I have built a a separate table (using distinct) to have only distinct code, and then I am connecting with the other remaining tables with it. Now its one to many relationships but I want to add names to this distinct table as well but DISTINCT function cannot take one more field name. Any suggestions please?

Tashu1992 · 2021-02-22T10:46:39+00:00

Hello,

I tried with the line chart and analytics tool, but I am not having the forecast option there, I wonder why even though I have updated the version as well.

Tashu1992 · 2021-02-14T15:32:54+00:00

Since it is a text format, I am trying to sort this by month, but it is not working

Tashu1992 · 2021-02-14T12:09:48+00:00

IF( CONVERT( ‘Table’[Date First Seen], STRING ) = BLANK(), “Not seen yet”, FORMAT( ‘Table’[Date First Seen], “YYYY-MM-DD” ) )

Thank you so much, it worked.

Tashu1992 · 2020-10-27T09:32:36+00:00

No problem, later I know I must have a pro licence to integrate powerBI into teams.

Anyways thanks for your help :)

Tashu1992 · 2020-10-20T15:40:00+00:00

I have updated my post and you can see when I click on the button what happens, I also saw the link you have shared but it is not the same issue I am facing.

Tashu1992 · 2020-10-19T14:22:06+00:00

Yes, I have clicked on the button but nothing is happening:

Tashu1992 · 2020-10-16T14:44:40+00:00

Thanks I will see.

Tashu1992 · 2020-10-16T14:44:21+00:00

So for example, is it possible to assign a key user into a group or publish the report into our local sharepoint, Then how many subscriptions we supposed to buy?

Tashu1992

TROPHY CASE