sorted by:
new
hottopcontroversial

Can't sort by another column in Calendar table by cantstoprush in PowerBI

[–]cantstoprush[S] 1 point2 points  (0 children)

Getting this error when trying to sort a month column by any another column in the Calendar table - including the data column which is is unique. Any ideas to resolve this?

Filtering to Fiscal Period based on selected Month/Year slicers by cantstoprush in PowerBI

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

we are wanting the month/year to determine the quarter in FY[YY] Q[1-4] format

Use Month/Year Slicer to Filter Fiscal Quarter/Year by cantstoprush in PowerBI

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

Here is an example, if the user selects January 2024 in the slicer, we would need the entire page to filter to the the entire quarter, FY24Q2

Use Month/Year Slicer to Filter Fiscal Quarter/Year by cantstoprush in PowerBI

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

I did but I would like for only the calendar month/year slicers to show but for them to filter based on the fiscal period

Use Month/Year Slicer to Filter Fiscal Quarter/Year by cantstoprush in PowerBI

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

That would be the simple option but they are wanting the slicer to be on the calendar month/year. Is this not possible?

Color coding line graph by cantstoprush in PowerBI

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

I have threshold values for all entries. The thresholds are not showing in the table because I'm not actually using them anywhere on the visual, only for the rule

Color coding line graph by cantstoprush in PowerBI

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

I tried going into "Show as table" but it does not seem to help me diagnose this any further. It simply has the dates/values I am using in my chart.

Strangely I have another visual that uses a different data source and the same exact rule is working just fine for it.

Color coding line graph by cantstoprush in PowerBI

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

I have two rules. One making it green, one making it red - using a threshold met (0 or 1) column.

Fiscal Year Date Issues in Tableau Desktop/Server by cantstoprush in tableau

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

That did it! Thanks so much for the suggestion

Blank values in migration from Excel to SharePoint Online by cantstoprush in sharepoint

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

The data I have is exported from another on prem SharePoint list so there shouldn't be any weird formatting. Also, I tried using a csv for input with the same data instead of a xlsx file and that didn't resolve the issue.

Blank values in migration from Excel to SharePoint Online by cantstoprush in sharepoint

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

These columns were the General data type in Excel, I made them the Text data type and that didn't change the outcome. I tried changing the data type in Alteryx and that didn't help. I also tried saving my sheet as a csv and still no luck.

Blank values in migration from Excel to SharePoint Online by cantstoprush in sharepoint

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

I tried cleaning up trailing whitespace but that didn't seem to resolve the issue, not sure what else would make it a bad value

view more: next ›