Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Hi Again, #539

Closed
B50RIV opened this issue Nov 13, 2023 · 12 comments
Closed

Hi Again, #539

B50RIV opened this issue Nov 13, 2023 · 12 comments

Comments

@B50RIV
Copy link

B50RIV commented Nov 13, 2023

Hi Again,
Another thing that is strange is that if you navigate between Jan and Feb a few times, the hierarchy for a row expands to the underlying level.
I realy hop you can help me.

image

Originally posted by @B50RIV in #538 (comment)
@AndersAano
Copy link
Contributor

@B50RIV,
Did we fix this by using Dim_tables?

-Anders

@B50RIV
Copy link
Author

B50RIV commented Nov 21, 2023 via email

@B50RIV
Copy link
Author

B50RIV commented Nov 21, 2023 via email

@AndersAano
Copy link
Contributor

Ho @B50RIV ,

The option "show items with no data" needs to be turned on in order for the structure to stay intact.

There is a limit on how much data can be added to the visual. If you add to much, you will have to apply a filter to reduce the amount of data (e.g. slice on department, time, market).

Another solution would be to add a separate page for all the details, and use that as a drill-through destination, meaning you can go from a summary table to a detailed page.

Last alternative is to upload a separate version of the visual to Organizational Visuals. We have one version with a much higher data limit, but it's not in AppSource due to potential performance issues (a lot of data => slow visual => not passing certification). Apart from the data limit, it's identical to the one currently in AppSource.

Best regards
Anders

@B50RIV
Copy link
Author

B50RIV commented Nov 22, 2023 via email

@B50RIV
Copy link
Author

B50RIV commented Nov 27, 2023 via email

@B50RIV
Copy link
Author

B50RIV commented Nov 27, 2023 via email

@AndersAano
Copy link
Contributor

AndersAano commented Nov 27, 2023 via email

@B50RIV
Copy link
Author

B50RIV commented Dec 14, 2023 via email

@AndersAano
Copy link
Contributor

Hi @B50RIV ,
In Edit mode, right click the column where you want to apply the formatting, and select "Add Conditional formatting":
image

Then chose the conditions, and select a style you want to apply where the conditons are true:
image

Finally format that style in the format pane:
image

Based on that, you will see something like this:
image

If you want icons, you can add a new column where you type in something like this:
image

You get icons by clicking the Windows-key and dot at the same time:

Win+.

However, the icons needs to be written in a notepad or someplace else, and then copied before they can be pasted in to the formula.

-Anders

@B50RIV
Copy link
Author

B50RIV commented Dec 21, 2023 via email

@AndersAano
Copy link
Contributor

Hi,

"Add column" is a premium feature. You can add a second measure, and use "Add column formula" on that measure to achieve something similar.

Best regards
Anders

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@AndersAano @B50RIV