Поддержка Power BI

Поиск

Re: find current quarter in DAX query

HI @vasu_479,   I'd like to suggest you use today function to extract current year and quarter as filter parameters.   Regards, Xiaoxin Sheng

Query SPO users and permissions?

Is there anyway to query the users of an SPO site or site collection and all their permissions?   We want to look at doing some security auditing but would really want a way to be able to do t...

Re: Horizontal bar charts showing deviation from 0?

That is exactly it kind Sir. What was the measure used?

Re: Setting up data for a matrix table

Thank you for the advice. I had to reorganize my data to add category and sub category columns with all of the individual variable values stored in their own row.

Re: Lookup with switch case

@AlB Yeah should've mentioned earlier, sorry about that. There is a 1:* relation between job and invoice tables i.e. one job can have multiple invoices but not the other way around.    ...

Re: Last Month calculations do not work in January - Status changed to: Delivered

@v-yuezhe-msft I would like to state that just because I found a workaround doesn't mean the root problem is resolved. I disagree with the status being "delivered", and suggest that Microsoft st...

Re: CALCULATE produces a blank result with a seconde FILTER

I thought it was enough. Here a screenshot of the sample the status part is simply another column that I have aggragated from the query onto PBI from another table. But it is as it in PBI.

Re: Lookup with switch case

Hi @AlB,   I was not aware about the Return function, Thanks!   One small issue, the job ids in the invoice table aren't unique. Hence while looking up, i get the error: "A ta...

Re: Show all detailed data labels PIE CHART

When I use slicer functionalty and select all it's the same result there's no change. 

Re: Scatter Chart with Lines Comparing One Series to Another

There really should be a solution to show min/max values in this format.  The suggested solution here by MAQ does not meet the need. There's no opitons to apply data labels or cateogize the Y ax...

Re: rolling 12 month that starts over at the year

I actually tried that, but I think had the year () wrong somewhere. Thanks!

Re: Group Records by Month then calculate Percent

This worked really well for what I needed as well, but I have one issue left in that this graph no longer responds slicer or visual filters. Is there a way to get this to still filter with the slicer...

Re: Is it possible to add counts next to slicer field?

@MFelix State Count = Table1[state_code] & "  "     & CALCULATE ( COUNT ( Table1[state_code] ), ALLEXCEPT (Table1, Table1[state_code]  ) )   This format work...

Show when either or both columns are greater than a value

Hello,    I have two columns with different values and I am trying to filter it so that I can only see the rows when the amount of both or either is greater than 5000.  I am trying ...

Multiple Tables

Hi    I am trying to import data from an excel that has multiple tables formatted like this. Three tables are included, New Employees, Employee variations and Leaving Employees.  &n...

Re: Multi-Dimensional Json file to Table

Hi,   I'm curious to get your feedback on this json, I tried you use your method and it did not yield the results I needed.  I was able to accomplish the multi-layered expansion...

Adding an Index Column based on more than one field

Hi all,   I am trying to create an index column based on 3 fields:  FORMULAID ITEMNUMBER GROUPNAME   Currently, the table looks like this:   But, I need it to l...

Any good ideas on text wrapping?

Hey. We would like to use a text wrapping on longish text to a circle    https://beta.observablehq.com/@mbostock/fit-text-to-circle This feels a bit cumbersome, and we noticed that PBIV...

Re: Sharing - tearing my hair out!

She has indeed, but for thoroughness, I asked her to go through the steps to access it in the web service, and then the Modern Sharepoint site again, and for the first time in 2 weeks today it worked...

Inside, into date Interval

Hello community!   I have a dates of check in and check out. And depending of the date filter, I need a KPI with a count of people inside. I use a measure that is good to table, but not to KP...

Re: A column based on the last value in a different column

@WojciechP   Hey!   I typically use LOOKUPVALUE for situations like this.   Here is a link to documentation on that that particular function:   https://docs.microsoft.com/...

Re: Users being asked to upgrade to pro to access app workspace shared on Premium capacity

@GilbertQ thanks for your reply I will be eventually creating Apps for each of 3 workspaces.

Re: AVERAGE including blanks when want it to ignore blanks and 0's by default

@po,   You can create a measure using DAX like pattern below: Result = AVERAGEX ( FILTER ( Table, Table[Value] BLANK () ), Table[Value] ) Community Support Team _ Jimmy Tao I...

Re: RANKX gives another value with filter

@Kanivan,   Could you share some sample data and clarify more details about the expected result?   Community Support Team _ Jimmy Tao If this post helps, then please consider Acce...

Re: Monthly values on the same row into column chart

Hi @rog_bjo, Based on my test, you could refer to below steps: Unpivot all your month columns in query editor: Import custom visual from market place and choose the Infographic desi...