Search found 52 matches

by Steve_D
Fri Sep 15, 2017 9:19 am
Forum: Power BI Desktop/Service
Topic: Where does PBI Service get its Date/Time settings?
Replies: 0
Views: 232

Where does PBI Service get its Date/Time settings?

Hi there, I'm wondering if anyone knows of a setting that tells Power BI Service to use local Date/Time settings. I have Now() function which reports the date a report is refreshed but when it is uploaded to the service the Now() function reports an earlier date (the day before date). I can't see an...
by Steve_D
Fri Sep 01, 2017 9:34 am
Forum: PowerPivot/DAX
Topic: Calculating the remainder
Replies: 1
Views: 243

Calculating the remainder

I had a business problem where I filtered a data set with multiple customers which was related to a sales table to show the sales to a customer that was selected. Pretty normal but, then I wanted to know what the sales where for the remaining customers... all others with the exception of those I had...
by Steve_D
Mon May 29, 2017 8:58 am
Forum: Power BI Desktop/Service
Topic: Is this even possible in Power BI
Replies: 4
Views: 565

Re: Is this even possible in Power BI

Thankyou , I was unaware that you could do that.
by Steve_D
Sun May 28, 2017 1:31 pm
Forum: Power BI Desktop/Service
Topic: Is this even possible in Power BI
Replies: 4
Views: 565

Re: Is this even possible in Power BI

Thankyou for the suggestion. The issue I found with the, "Enter Data" Table was once the data had been entered the Table became fixed with those values. I was after something I could change the values in the table while in Power BI. From what I've seen, this is not possible in Power BI. To...
by Steve_D
Fri May 05, 2017 10:28 am
Forum: Power BI Desktop/Service
Topic: Risk matrix chart in Power BI
Replies: 6
Views: 1298

Re: Risk matrix chart in Power BI

very clever, I hadn't even thought of that but again as long as you create a formula that constrains the range to a static four quadrants then this would work to. Surely we have a Mathematician in the ranks who can share a formula that will constrain a range of data to a values that range between -1...
by Steve_D
Thu May 04, 2017 12:16 am
Forum: PowerPivot/DAX
Topic: Help with calculating %
Replies: 1
Views: 431

Re: Help with calculating %

I'm not sure if this helps but, if I understand your example correctly what you are trying to ascertain (as an example) is the % the "On Boarding" type is of "Requests"? therefore, wouldn't it be; Numerator: Count of Request Type = Count(Table[Req type]) Denominator: Count of All...
by Steve_D
Mon May 01, 2017 2:48 pm
Forum: Power BI Desktop/Service
Topic: DAX MTD , QTD , YTD Returning Blanks
Replies: 1
Views: 512

Re: DAX MTD , QTD , YTD Returning Blanks

Hate to post a dumb response but, anyway for sake of discussion, is your Date.Dim field a contiguous set of dates?
by Steve_D
Mon May 01, 2017 9:33 am
Forum: Power BI Desktop/Service
Topic: Is this even possible in Power BI
Replies: 4
Views: 565

Is this even possible in Power BI

G'day, Is there a way of entering data at the canvass level either in Power BI Desktop or Power BI Service. What I'm trying to do is create a table with a list of customer groups and then have a user provide a scalar value which is input in the table and then used as adjustment factors for other DAX...
by Steve_D
Mon May 01, 2017 9:19 am
Forum: Power BI Desktop/Service
Topic: Risk matrix chart in Power BI
Replies: 6
Views: 1298

Re: Risk matrix chart in Power BI

G'day, I have similar problem in that I want to assign data to quadrants and then filter the data by quadrant or data point. Let me predicate this with, "I haven't done this yet" but,what I was going to do was overlay a Chiclet slicer over a scatter plot (send the scatter plot to the backg...

Go to advanced search