cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sajarac Member
Member

Synoptic Panel by OKviz question

Hello there,

 

Quick question using this visualization tool.

 

I have a custom calendar, I would like to link that calendar with my excel file file as follow:

 

In my excel file I have two columns

Day = All the days in a month 1-31

Status = could be 1,2,3,4,5

 

Depends on the day the user choose from 1-5

 

Being 1= Green, 2= Yellow, 3=Red, etc.

 

What I have so far is every single day I am getting a different color. 

 

How can I change to reflect my color scale from 1 to 5?

Untitled.png 

 

Thank in advance

 

1 ACCEPTED SOLUTION

Accepted Solutions
mwimberger Regular Visitor
Regular Visitor

Re: Synoptic Panel by OKviz question

Hi @sajarac 

 

I think I solved it. The documentation on the Okviz site is a little dated but it is to do with the states field. 

 

Here is what I came up with using your file. I will repost this to you in IM and you can see if this helps.

 

Cheers

 

Manfred

2019-07-23_10-47-34.jpg

11 REPLIES 11
mwimberger Regular Visitor
Regular Visitor

Re: Synoptic Panel by OKviz question

Hi @sajarac 

 

I've used this visual a little before  and the legend colour  is based on the category. In the Format tab of this visual,  you can select this under Data Colors, if you have the Status ( 1-5) under Category.

 

I've just used a map visual ( completely wrong for the example I know ) but hopefully it illustrates the solution.

 

Synaoptic okviz.jpg

sajarac Member
Member

Re: Synoptic Panel by OKviz question

Hello, and thank you very much for your prompt response.

 

The problem that I have is, I guess the visual is using the column day and "Summing" or Counting"

 

As you can see the square for day 5 is showing Day = 164, which is basically summing the "Status" column where is equal to 5.

 

Untitled.png

mwimberger Regular Visitor
Regular Visitor

Re: Synoptic Panel by OKviz question

Hi  @sajarac 

 

Ah, ok, so to correct that you need to set the day to not autosum. The clue that that is happening, is the sigma (Σ) sign next to "day". To get rid of this , go to the modelling tab of the Desktop, and choose don't summarise. You could choose minimum or better yet, define a measure for this.

 

2019-07-23_8-27-27.jpg

sajarac Member
Member

Re: Synoptic Panel by OKviz question

Hi there,

 

I am doing something wrong, for some reason I am not getting the full chart with the colors.

 

The first snapshot is Category = Status, Measure = Count of Day "I have changed to Don't sumarize"

 

The second screenshot is the opposite.

 

The first one seems like is writh but is only showing up to day 6.

 

Sorry :-(

 

 

Capture1.PNGCapture2.PNG

 

 

mwimberger Regular Visitor
Regular Visitor

Re: Synoptic Panel by OKviz question

Hi @sajarac 

 

Are you using a custom made .SVG for the visual? If so could you share that with me please.

sajarac Member
Member

Re: Synoptic Panel by OKviz question

Sure,

 

I will send you a PM.

 

Thank again for your help.

 

 

mwimberger Regular Visitor
Regular Visitor

Re: Synoptic Panel by OKviz question

Hi @sajarac 

 

I think I solved it. The documentation on the Okviz site is a little dated but it is to do with the states field. 

 

Here is what I came up with using your file. I will repost this to you in IM and you can see if this helps.

 

Cheers

 

Manfred

2019-07-23_10-47-34.jpg

sajarac Member
Member

Re: Synoptic Panel by OKviz question

Thank you, thank you, thank you!!!!!

 

I would not have guessed....

 

I really appreciate all the help.

 

Regards.

sajarac Member
Member

Re: Synoptic Panel by OKviz question

Hi there, sorry to bother you again. This is justa a quick question:

 

Is possible to add a label with the day name?

 

Thanks in advance.

 

Regards,

 

labels.PNG

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 42 members 991 guests
Please welcome our newest community members: