Forum

Can you please give me an example of what you expect and what it's returning based on the file you provided so we can focus on one example to troubles...

Hi Alison, The Table filters for me when I click on a column in the chart. Mynda

Hi Chen, The Date table should only contain one record for each date in the year(s). If you're getting a many to many error then the Date table mus...

Hi Scott, Welcome to our forum. I suspect your question hasn't been answered because we're not sure what you mean by 'Profile'? Perhaps you can upl...

Hi Kerry, Welcome to our forum. I know very little about SharePoint, so much of the terminology you reference means nothing to me, sorry. That s...

Hi Alison, You need two queries, the first one is your calendar query, the second one references your calendar query and groups the dates by MthYea...

Hi Aye, The stacked column chart is the wrong visual for this data. A bar chart is better, see example attached. Note: you don't have any date info...

Hi Sandeep, Lots of things can affect the sort order, however if you're simply appending the queries and not performing any cleaning or filtering t...

Hi Safirah, Thanks for sharing your file. In the attached file you'll see I've included a measure for the FBL Total Not Overdue. You need the Due D...

Hi Aye, In a bar chart the 'axis' field is the vertical axis. The horizontal axis will automatically populate based on the data. Thanks for shar...

Hi Aye, You can't force the legend to fit on the chart. I would argue that if you can't see all of the legend items then you're probably not using ...

Hi Safirah, Yes, you'd need a measure for this. If you want some help with it please upload a sample Excel file containing your Power Pivot model. ...

Hi Firah, This is a PivotTable limitation in that you can't specify a date format, sorry. The workaround is to add the date format as text to your ...

Hi Aye, Number formatting is set on the Modelling tab in Power BI. Mynda

Hi Aye, Please see attached. Note: I've removed the earlier questions, changed the title of this post and moved it to the Power Query forum. In ...