Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Data reduction algorithm

Hi,

 

im working on custom visual that returns this error: "too many 'Task No' values" Not displaying all data. Filter the data or choose another field."

 

I tried to fix this according the data reduction algorithm: https://github.com/mvgaliev/PowerBI-visuals/blob/942d72065ec6703878249d32cb8df41a00827750/Capabiliti...


The error is due to "tasks".

so i tried this: (on capabilities.json)

 

    "categorical": {
                "categories": {
                    "select": [
                         {
                            "for": {
                                "in": "Task"
                            } , "dataReductionAlgorithm": {
                                "top": {
                                    "count": 30000
                                }
                            }
                        }, 
                        {
                            "for": {
                                "in": "Parent"
                            }
                        },
                    
                        {
                            "for": {
                                "in": "StartDate"
                            }
                        },
                        {
                            "for": {
                                "in": "Resource"
                            }
                        }
                    ]
                },
                "values": {
                    "group": {
                        "by": "Legend",
                        "select": [
                            {
                                "for": {
                                    "in": "EndDate"
                                }
                            },
                            {
                                "for": {
                                    "in": "Duration"
                                }
                            }
                        ]
                    }
                }
            }

 

But it seems to have no affect. I also tried to set property to "window" or "bottom" and reduce count.

 

1 REPLY 1
Anonymous
Not applicable

solved:  

In my case it was necessary to place it after select in "categories" and "values"

 

 

  "categorical": {
                "categories": {
                    "select": [
                        {
                            "for": {
                                "in": "Task"
                            }
                        }, 
                        {
                            "for": {
                                "in": "Parent"
                            }
                        },
                    
                        {
                            "for": {
                                "in": "StartDate"
                            }
                        },
                        {
                            "for": {
                                "in": "Resource"
                            }
                        },
                        {
                            "for": {
                                "in": "ParentResource"
                            }
                        },
                        {
                            "for": {
                                "in": "ExtraInformation"
                            }
                        },
                        {
                            "for": {
                                "in": "Milestones"
                            }
                        }
                    ], "dataReductionAlgorithm": {
                        "top": {
                            "count": 30000
                        }
                    }  
                },
                "values": {
                    "group": {
                        "by": "Legend",
                        "select": [
                            {
                                "for": {
                                    "in": "EndDate"
                                }
                            },
                            {
                                "for": {
                                    "in": "Duration"
                                }
                            },
                            {
                                "for": {
                                    "in": "Completion"
                                }
                            }
                        ], "dataReductionAlgorithm": {
                        "top": {
                            "count": 30000
                           }
                        }  
                    }
                }
            }

 

 

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors