Git Product home page Git Product logo

powerbi-visuals-attributeslicer's Introduction

Build Status

AttributeSlicer

Attribute Slicer lets you filter a dataset on a given column by selecting attribute values of interest. The initial display is a helpful overview that lists the most common values first and shows the overall distribution of values as a horizontal bar chart. Whenever you select an attribute value, it is moved to the list of applied filters and all records containing that value are added to the result set for further analysis.

Attribute Slicer

This visual is experimental and not actively being developed, only major issues will be addressed.

Usage

  • Install node.js 6+
  • Install yarn
  • Run yarn on the project directory, which will install all the dependencies
  • Run yarn test which will lint, test, and compile the attribute-slicer and attribute-slicer-powerbi packages.
    • Compiling attribute-slicer-powerbi will also create a .pbiviz file in the packages/attribute-slicer/powerbi/dist directory, which can be imported directly in Power BI
  • Run yarn start, which will load the powerbi visual into live reload mode.

powerbi-visuals-attributeslicer's People

Contributors

darthtrevino avatar eric-kimbrel avatar iwong-uncharted avatar jryu01 avatar microsoft-github-policy-service[bot] avatar stopyoukid avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

powerbi-visuals-attributeslicer's Issues

Search terms not cleared after category change.

repro

  1. Select a category and perform a search to narrow down the results
  2. remove the category then add it again
  3. click to another page and then back

expected: search field is blank and no search filter is applied
actual: search field is present with previous search / filter applied

Single select doesn't restore selection correctly

If you have the single select option turned on in PBI, make a selection, switch pages, and go back, attribute slicer will restore the selection, then quickly clear it. This does not occur with multi-selection.

Counts in small bars are not visible

If the bars with the counts are 1px wide, the count value cannot be read by the user. It would be nice to have a setting that moves the counts to the right of the bar in a different color when they don't fit, so the count is visible there, for example.

The default sort should be by numeric value

When using the Attribute Slicer visual you specify 'Items' and 'Values'. Whenever a Values property is specified the default sort should be by value.

It seems that the most common use for this visual is to bring the most popular items to the top of a list.

Bug when select value in 2 object of attribute slicer

I have 2 object of attribute slice in my application, when value in the first object is selected, everything going well, but when i select one value in the second object, then something going wrong, selected value in the second object is like select-hide-select-hide.

Hope this bug can fix soon, because i really need this object.

try on attribute slicer version 0.12.1

Note: attribute slicer version 0.11.6 is good, but i need thousand delimiter in the value, so i have to modification in your code, but in version 0.11.6, i can't build this object because one of your library is missing (essex.powerbi.base)

thank you.

Selection off by one with Hide Empty Values

When using the hide empty values option the selection does not select the correct values in power bi.

This is because when hiding empty items we filter them out of the underlying data object, we then use that object for selection logic but as it no longer matches power-bi's view of the data the wrong thing can be selected.

Add ability to specify the default color

Attribute Slicer will use a teal color when you use just a category and a value field, but there is no way to customize that color. You can only customize if you drag in something into the "Segmented By" field.

Add "Select All" option

This is useful when you have searched for something and want to apply a filter using all of the results. One issue is what if there are 100+ results (how do we select them without loading the entire dataset)?

"Shift select" feature appears to have broken in July 2017 Power BI update

The "Shift select" feature appears to have broken in July 2017 Power BI update. When Single Select and Brush Select are both off, it used to be possible to click an item, hold Shift, click another item, and select multiple items.

Now, just the items which are clicked are selected. So, if a user wants to select 100 items, they would need to click 100 times.

Error with the pbiviz

Hello

When i tried to generate the pbiviz with the command yarn test I got this error :

image

It says '!' is not recognize as an internal command.

Did I miss something ?

UI Consistency

Make consistent with all of the other visuals: Padding, Margin, Borders, Font Colors/Sizes...

Add Y-Axis Formatting Options

Simple for now:

  • Have an On/Off option for the the Y-Axis (Default to Off)
  • Have a Drop down to configure Left/Right side of the visual

Multiple Category Select Error

Issue seen on the switch-to-filtering branch.

Add two items (categories) to the attribute slicer and select a row. Filter is not applied to other visuals and an error is shown in the java script console.

powerbiportal.common.bundle.js:25414 UnhandledAngularException: Cannot read property 'findProperty' of undefined (caused by "undefined")
TypeError: Cannot read property 'findProperty' of undefined
    at SQColumnRefExpr.SQExpr.getConceptualProperty (https://msit.powerbi.com/13.0.1700.2253/scripts/powerbiportal.dependencies.bundle.js:23684:25)
    at SQColumnRefExpr.SQExpr.getMetadataForProperty (https://msit.powerbi.com/13.0.1700.2253/scripts/powerbiportal.dependencies.bundle.js:23789:37)
    at SQColumnRefExpr.SQExpr.getMetadata (https://msit.powerbi.com/13.0.1700.2253/scripts/powerbiportal.dependencies.bundle.js:23619:33)
    at SQExprValidationVisitor.validateCompatibleType (https://msit.powerbi.com/13.0.1700.2253/scripts/powerbiportal.dependencies.bundle.js:25369:41)
    at SQExprValidationVisitor.visitIn (https://msit.powerbi.com/13.0.1700.2253/scripts/powerbiportal.dependencies.bundle.js:25189:34)
    at SQInExpr.accept (https://msit.powerbi.com/13.0.1700.2253/scripts/powerbiportal.dependencies.bundle.js:24182:32)
    at SemanticQueryRewriter.rewriteWhere (https://msit.powerbi.com/13.0.1700.2253/scripts/powerbiportal.dependencies.bundle.js:26437:105)
    at SemanticFilter.rewrite (https://msit.powerbi.com/13.0.1700.2253/scripts/powerbiportal.dependencies.bundle.js:27290:38)
    at SemanticFilter.validate (https://msit.powerbi.com/13.0.1700.2253/scripts/powerbiportal.dependencies.bundle.js:27295:22)
    at FilterGenerator.shouldApplyFilter (https://msit.powerbi.com/13.0.1700.2253/scripts/powerbiportal.explore.bundle.js:9725:43)

Revoke private key or add comment indicating the reason it has been committed

It is a security best practice to never commit a secret, especially within a publicly viewable repository. However, the following file has been committed to your repo:

  • PowerBI-visuals-AttributeSlicer/packages/attribute-slicer-powerbi/certs/PowerBICustomVisualTest_private.key

To resolve this issue, either revoke this key and remove it from the repo, OR add a comment indicating both why it is necessary to have this private key and why it is not a security risk.

PBI occasional desktop crash

Stack Trace:

Microsoft.Mashup.Host.Document.JavaScriptException: An error occurred while rendering the report. TypeError: Cannot read property 'pageYOffset' of undefined at n.fn.extend.offset (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.1.1.js:4:18213) at e.<anonymous> (https://visuals.azureedge.net/prod/AttributeSlicer1652434005853.js:28:8662) at delayed (ms-pbi://pbi.microsoft.com/minerva/scripts/powerbi.common.externals.js:35772:27)

This is occuring in the updateListHeight call. I presume the issue is that updateListHeight is called, then the slicer is destroyed, then after the debounce, updateListHeight completes, but by that time, the elements are gone, causing PBI to crash.

Power BI filters not applying to Attribute Slicers

When I apply a power BI visual filter using, say, the shape map filter. It does not filter down the attribute slicers. E.g. I filter the shape map on CA and it should show only the west region option in my "region" attribute slicer filter (as other regions are not relevant for CA). It was working this way before. It works in power BI desktop just not when a report is published to power BI service.

Scroll not working on Edge

Scroll is not working when we try to drag the scroll using mouse pointer. Following are the steps to reproduce the issue:

  • Download the sample from pbix file from https://app.powerbi.com/visuals
  • Set the view to 'Fit to width'.
  • Publish the report to a workspace.
  • Open the report in Edge browser.

When we try to scroll the item list area by dragging the scrollbar, the scroll is not working. It is giving a lot of problem to the Edge user. Please fix the issue ASAP.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.