Forum Discussion
Table/Matrix doesn't load when published to pbi apps
Hi,
Having problems with table/matrix when publishing it to apps pbi website. Loading circle just spins and nothing happens even after 15 min.
The problem is with conditional formating. If I publish without it, table loads.
I have 2 conditional formats for profit and net, both are the same formula with different variables:
ColorProfit = IF(ISBLANK(ST030200[CurrentYearProfit]); ""; IF(ST030200[CurrentYearProfit] > pbi_Budget[Profit Budget] && ST030200[CurrentYearProfit] > ST030200[LastYearProfit]; "#9cf88c"; IF(ST030200[CurrentYearProfit] > pbi_Budget[Profit Budget] && ST030200[CurrentYearProfit] < ST030200[LastYearProfit]; "#fff68f"; IF(ST030200[CurrentYearProfit] < pbi_Budget[Profit Budget] && ST030200[CurrentYearProfit] > ST030200[LastYearProfit]; "#fff68f"; IF(ST030200[CurrentYearProfit] < pbi_Budget[Profit Budget] && ST030200[CurrentYearProfit] < ST030200[LastYearProfit]; "#ff6666"; "")))))
On Desktop table works, it takes more time to load, but I think it's fair. But when published it never loads. Anyone have ideas why that might be?
2 Replies
Try using Switch instead of If in DAX and try using both Hex code and color name and see if one of them works.
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting
Tried it. Same thing. Doesn't load in web with switch and doesn't matter if I use names or hex codes.
Will try to calculate colors in seperate table before applying to table. Might be that too much calculations needed.
In web it loads after 20 min :)
